Converting from upper case to lower case

S

Simple

How do I convert an Excel spreadsheet which is in upper
case to lower case (first letter in the cell must be in
upper case)? Any help will be greatly appreciated. Thanx
Simple
 
S

Simple

Hi thanks for your replies but the propoer functional
only converts one cell at a time. Is there a way to
convert either an whole column or the complete work sheet?
 
P

Peo Sjoblom

J.E. gave you a link to D. McRitchie's page where there is a macro that will
do this,
that is the only (obviously) way to convert a range of text to proper. If
not copy the formula
down/across or use it from another sheet

=PROPER(Sheet1!A1)

copied across and down, then copy and paste special as values in place.


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top