Converting from upper case to lower case

  • Thread starter Thread starter Simple
  • Start date Start date
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
 
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?
 
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)
 
Back
Top