Posted to microsoft.public.excel.misc

Lisa5015

external usenet poster

Posts: 1

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting Columns	Jessica	Excel Discussion (Misc queries)	4	July 9th 07 07:22 PM
Formatting Columns	Aline	Excel Discussion (Misc queries)	1	April 4th 07 08:44 AM
Columns formatting	Maksko	Excel Discussion (Misc queries)	2	February 2nd 07 09:42 AM
formatting columns by date	JR Jen	Excel Worksheet Functions	1	May 24th 06 06:30 PM
Formatting Columns	wg100	Excel Worksheet Functions	3	October 26th 05 10:15 AM

All times are GMT +1. The time now is 07:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us