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" wrote in message
...
how do i change an existing cell or cells to upper case?