Lowercase
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
=PROPER(A1)
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).
