Posted to microsoft.public.excel.worksheet.functions

pow835

Posts: n/a

How can I use one formula to change case on an entire worksheet?

I inherited a worksheet where some of the names are typed on all caps. Is
there an easy way to change the case on those cells without selecting each
cell individually and using the PROPER function?

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
how to use spellnumber formula	Aarif	Excel Worksheet Functions	3	February 27th 06 04:36 PM
VBA	Monty	Excel Worksheet Functions	2	January 30th 06 01:37 PM
VBA Code	Cell Mate	Excel Discussion (Misc queries)	4	January 9th 06 08:52 PM
I NEED HELP with the SPELLNUMBER Function	vag	Excel Worksheet Functions	0	June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS	vag	Excel Worksheet Functions	1	June 15th 05 05:57 PM

All times are GMT +1. The time now is 02:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us