View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa5015 Lisa5015 is offline
external usenet poster
 
Posts: 1
Default Help with formatting columns.

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!