Changing Case

R

RJB

I have a report that is ALL CAPS, which offends me aesthetically...

What I have been doing is:

Ex: COLUMN A IS ALL CAPS

Insert Column B;
=Proper(A1)
Select Column B
"Copy"
Select Column A
"Paste Special... Value" over Column A
Delete Column B

SURELY there is a way to "overlay" the change in formatting in one step?

Thanks
 
C

cwilson

If you do the same steps each time to get your desired result, youcould
record them using the macro recorder. Then you would only have to run the
macro to make the changes.

Go to Tools > Macro > Record New Macro save the macro in your PERSONAL
workbook. Do your steps, then stop the recording.

HTH
cwilson
 
Top