ExcelBanter - How do I create upper/lower case letters in cells?

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

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

- - How do I create upper/lower case letters in cells? (https://www.excelbanter.com/excel-discussion-misc-queries/45371-how-do-i-create-upper-lower-case-letters-cells.html)

boz130

How do I create upper/lower case letters in cells?

I have a large spreadsheet with names/addresses that are all capitalized. I
want to make them upper and lower case (SMITH = Smith). What's the formula?

David Hepner

You could create helper cells with this formula

=proper(A1)

"boz130" wrote:

I have a large spreadsheet with names/addresses that are all capitalized. I
want to make them upper and lower case (SMITH = Smith). What's the formula?

All times are GMT +1. The time now is 08:25 AM.