I agree with you, upper case is both ugly and hard to read,
you must use a macro to do it in one fell swoop

http://www.mvps.org/dmcritchie/excel/proper.htm#lower

same site has a section how to install macros as well,

http://www.mvps.org/dmcritchie/excel/install.htm


Regards,

Peo Sjoblom

"RJB" wrote:

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