Insert a helper column. Enter the formula =proper(a1), and copy down. Copy the
new column, and Paste SpecialValues the old column. Delete the helper column.
Repeat for each column.

You will probably have to manually correct some names, especially last names
beginning with Mc and Mac.

--
Regards,
Fred


"dennis blaz" wrote in message
...
I was sent an Excel spreadsheet with names and addresses, it's all in upper
case and I want to change the entire document to "proper" case. Please help!

Ps. 861 names w/ 7 columns