I have a database that has first names in Title Case and last names in ALL
CAPS and Addresses and Cities that are half and half.

Does anyone know how to format the COLUMN so that I can have the first
letter of every word in CAPS and the rest of the word lower case?

I know how to format each cell individually, however there are over 6000
contacts in the database.

THANKS!

=Proper(A1)

and copy down

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Lisa5015" wrote in message
...
I have a database that has first names in Title Case and last names in ALL
CAPS and Addresses and Cities that are half and half.

Does anyone know how to format the COLUMN so that I can have the first
letter of every word in CAPS and the rest of the word lower case?

I know how to format each cell individually, however there are over 6000
contacts in the database.

THANKS!