MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jon on October 25, 2001 2:20 PM

I need to change the case on 300 hundred columns from

JONATHAN to Jonthan

I can do it in word, but does excel have this capability

Posted by Mark W. on October 25, 2001 2:31 PM

Use the PROPER() worksheet column.

Posted by Mark W. on October 25, 2001 2:32 PM

Oops... distracted for a moment

Use the PROPER() worksheet function.

Posted by Lars on October 25, 2001 2:33 PM


Posted by anon on October 26, 2001 2:38 AM

300 columns? How many sheets do you have?

Posted by Don C on October 26, 2001 5:16 AM

a Proper() caveate

PROPER changes the first letter or the first letter following a space to upper case and all subsequent letters to lower case. In last names, this means that McKay will come result in Mckay and NAME III will result in Name Iii.

When I use Proper, I use replace MC with MC(space), then do the PROPER, then replace the space with null. Also the Iii can be fixed with a replace (Name Iv also needs fixing).