ExcelBanter - Formula for changing all caps to lower case

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

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

- - Formula for changing all caps to lower case (https://www.excelbanter.com/excel-discussion-misc-queries/90299-formula-changing-all-caps-lower-case.html)

PFLY

Formula for changing all caps to lower case

Is there a formula that I can use to change LIMA OHIO to Lima Ohio, just the
first letters being in Caps and the rest in lower case?

Peo Sjoblom

Formula for changing all caps to lower case

=PROPER(A2)

Regards,

Peo Sjoblom

"PFLY" wrote:

Is there a formula that I can use to change LIMA OHIO to Lima Ohio, just the
first letters being in Caps and the rest in lower case?

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