I have a spreadsheet that consists of Names and Addresses, however they are
all in capital letters. There are about 600 entries. It'll take me forever if
I edit each one manually. What formula should I use to make the Names not all
caps. For ex. JOE SMITH becomes Joe Smith. Last Name is in one column and the
First Name in another column.

Please Help!

Thank you so much :)