From: dopy on
how do i change an existing cell or cells to upper case?
From: Fred Smith on
In an adjacent column, use the Upper function, as in:
=upper(a1)

You can then convert this to values, and delete the original.

Regards,
Fred

"dopy" <dopy(a)discussions.microsoft.com> wrote in message
news:9BE9E2CB-56E6-4DDC-9674-D78F4ACA5F9B(a)microsoft.com...
> how do i change an existing cell or cells to upper case?