How can I convert text to all lowercase?

  • Thread starter Thread starter HBYardSale
  • Start date Start date
H

HBYardSale

How can I convert text to all lowercase?

I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?

If not with Excel, how about Word, DOS, any other way.

I'm using Excel 7.0 (Office 95).
Thanks in advance!
 
In a blank cell to the side of the data, (say the data is in column A), type

=LOWER(A1)

Copy down as far as the data goes. Now copy this data and Edit>Paste
special...>Values over itself to 'kill' the underlying formula

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Thanks very much!!

=======
I have macros to convert to uppercase, lowercase, proper (title) case at
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

How do you convert to lowercase from the format menu in Excel, are you
perhaps thinking of MS Word (format, change case, ....)?.
 
Back
Top