Posted to microsoft.public.excel.misc

external usenet poster

Posts: 15

Formating Question

I have a long lists for of stores that contain texta and a number. I am
doing a Vlookup for this column but the formating is wrong. Here are
examples of what the two different texts look like. WalMart #01323 and
WALMART #001323 CARBONDALE (77757) Carbondale, IL. Is there a way to format
all of my cells in the second column to look like WalMart #01323? They arein
order but I can't drap because some of the numbers dont exsist.

Any help would be great

Adam

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
Conditional Formating (?) question	mmills421	Excel Discussion (Misc queries)	12	May 8th 08 10:00 PM
Formating Question	carl	Excel Worksheet Functions	7	November 16th 07 08:31 PM
Conditinal Formating question	carrera	Excel Discussion (Misc queries)	8	December 1st 06 11:24 PM
Formating question	toot033	Excel Discussion (Misc queries)	2	August 9th 06 06:35 PM
Formating Question Please	Bob Newman	Excel Discussion (Misc queries)	2	February 13th 06 02:33 PM

All times are GMT +1. The time now is 01:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us