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?

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?