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

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

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


"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