Capitalizing an existing column.

T

The Oz

I have entered an extensive amount of data, only to have management tell me
they want it all in upper case. Is there a way to do that without starting
over?
 
D

Duke Carey

Assume your data is in column A. In an empty column near your data enter the
formula

=upper(A1)

and copy it down as needed. After copying the formula to the necessary
cells, select all the formulas, copy them, select the original data, and use
Edit->Paste Special->Values to replace the original data with the upper case.
AFter confirming that the result is what you want, delete the column with
the formulas
 
Top