I am working on a spreadsheet with numerous text entries in all uppercase and
would like to change to lowercase. Is there a simple solution to this matter?
JE McGimpsey - 04 Sep 2007 22:02 GMT
See
http://www.mvps.org/dmcritchie/excel/proper.htm#lower
> I am working on a spreadsheet with numerous text entries in all uppercase and
> would like to change to lowercase. Is there a simple solution to this matter?
Gord Dibben - 04 Sep 2007 22:06 GMT
With QWERTY in A1, enter =LOWER(A1) in B1 to get qwerty
Gord Dibben MS Excel MVP
>I am working on a spreadsheet with numerous text entries in all uppercase and
>would like to change to lowercase. Is there a simple solution to this matter?