ExcelBanter - uppercase to lowercase

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - uppercase to lowercase (https://www.excelbanter.com/excel-programming/390989-uppercase-lowercase.html)

wagz

uppercase to lowercase

I have mixed case text in cells that I would like to have all in lowercase.
What can I use to make this happen?

Vergel Adriano

uppercase to lowercase

wagz,

With formulas, you can use the LOWER() function.

With VBA, you can use the LCase() function

--
Hope that helps.

Vergel Adriano

"wagz" wrote:

I have mixed case text in cells that I would like to have all in lowercase.
What can I use to make this happen?

wagz

uppercase to lowercase

Great! Works perfect. Thanks!

"Vergel Adriano" wrote:

wagz,

With formulas, you can use the LOWER() function.

With VBA, you can use the LCase() function

--
Hope that helps.

Vergel Adriano

"wagz" wrote:

I have mixed case text in cells that I would like to have all in lowercase.
What can I use to make this happen?

All times are GMT +1. The time now is 07:03 AM.