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