RJB

Posts: n/a

Changing Case

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing from upper case	Cecile	Excel Discussion (Misc queries)	6	December 16th 04 01:03 AM
Identifying the Active Fill Color	Steve Conary	Excel Discussion (Misc queries)	3	December 9th 04 04:45 AM
changing lower case to upper case	T. Campbell	Excel Discussion (Misc queries)	1	December 8th 04 05:37 PM
change typed text to upper case	CT Cameron	Excel Discussion (Misc queries)	2	November 30th 04 01:07 AM
How do I change existing text from lower case to upper case	CT Cameron	Excel Discussion (Misc queries)	2	November 30th 04 01:07 AM

All times are GMT +1. The time now is 12:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us