Posted to microsoft.public.excel.misc

ferde

external usenet poster

Posts: 87

wild card?? formula question please

A---------------B
S6N 561 6N
S6N 573 6N
S8N 345 8N
S9S 597 9S

I would like B2 to contain only the second and third character of the part
number listed in cell A2. I think I could use wild cards but havent been
able to get it to work. Can anyone tell me what formula I would use? Any
help would be greatly appreciated. Thank you

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
Using wild card in IF formula	gcukarski	Excel Discussion (Misc queries)	3	September 19th 08 12:22 AM
Wild card in two condition text formula	Dave Peterson	Excel Discussion (Misc queries)	0	March 3rd 06 06:33 PM
Wild Card Search	roy.okinawa	Excel Worksheet Functions	4	January 30th 06 10:42 PM
wild card -- help with formula	Michael A	Excel Discussion (Misc queries)	10	January 8th 06 10:15 AM
Wild card *	Herman	Excel Worksheet Functions	0	October 21st 05 01:39 PM

All times are GMT +1. The time now is 05:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us