ExcelBanter - Caps to lower case

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Caps to lower case (https://www.excelbanter.com/excel-discussion-misc-queries/3069-caps-lower-case.html)

Christopher Anderson

Caps to lower case

Is there a way to take text that is all caps and change it to all lower case?

Thanks

Chris

JE McGimpsey

WIth formulae, using a helper column:

=LOWER(A1)

or via macro, in-place:

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

In article ,
"Christopher Anderson"
wrote:

Is there a way to take text that is all caps and change it to all lower case?

Paulw2k

=LOWER(A1), where the uppercase text is in A1.

"Christopher Anderson" wrote
in message ...
Is there a way to take text that is all caps and change it to all lower
case?

Thanks

Chris

All times are GMT +1. The time now is 04:04 PM.