how do i change an existing cell or cells to upper case?

F

Fred Smith

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
 
Top