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?