Changing Case

D

Daniel - Sydney

Hi

I have Excel 2002 SP3

I have a spreadsheet with several columns, I need to change on of the
columns to all upper case.
The column is C and the data runs from C2 to C267.

I have looked in Help but cannot understand how to foolow the instructions,
I do not understand them.

Please advise how I can change the case.

regards
 
F

Fred Smith

I would do the following:

Insert a new column at D
In D2, enter =upper(c2)
Copy down to D267 (use the fill handle -- the little square on the bottom left
of the box)
Highlight D2 to D267 (it should still be highlighted from the copy down)
Copy (right click and choose copy)
In C2, right click and choose Paste Special, then values
Delete column D
 
D

Daniel - Sydney

Fred

worked like a dream, and I understood it, no worries.

thanks for your help

regards
 
Top