Converting from upper case to lower case

[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

 

[Andy Wiggins]

=PROPER()

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[JE McGimpsey]

See David McRitchie's Proper_case() macro:


http://www.mvps.org/dmcritchie/excel/proper.htm

 

[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?

 

[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)