Help with formatting columns.

G

Guest

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!
 
B

Bob Phillips

=Proper(A1)

and copy down

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change all text on Spread sheet 1
fix all caps text to first letter caps 1
How do I convert addresses to all caps in Office 2007? 3
how do you change a large group of all cap names to only there fi. 1
All Caps, / All Lower, not the function 5
Format Excel cells for "all caps", with Office 07? 4
Field formatting 3
remove duplicate records in Excel file 1

Top