I hope you meant =LOWER(A1) not =(LOWERA1) ?
--
David Biddulph

"Blondie and Dagwood" <Blondie and wrote
in message ...


"Maria" wrote:

Please e-mail me back ASAP, if there's a way to do this in Excel... I
know
WORD has it, but I can't seem to find it EXCEL

This worked for me:
Create a blank column to the right of the column you want to change upper
case to lower case - let's say your information is in Column A.
Type =(LOWERA1) in the first cell of the blank column. (If your info is
in
Column B, type B1, etc)
Click the corner of that cell and drag all the way down to the last cell
that has info in it.
Like magic, the letters were changed to lower case.
I still don't know how this worked after all I've read here, but it did.