ExcelBanter - Making all text become lower case

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

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

- - Making all text become lower case (https://www.excelbanter.com/excel-discussion-misc-queries/233183-making-all-text-become-lower-case.html)

amik

Making all text become lower case

I have a column of info with text and numbers.

Is there a way to make all the text become lowercase?

Thanks,

Adam

Jim Thomlinson

Making all text become lower case

Have you tried the Lower function...

=Lower(A1)
--
HTH...

Jim Thomlinson

"amik" wrote:

I have a column of info with text and numbers.

Is there a way to make all the text become lowercase?

Thanks,

Adam

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