Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup text within string of text???
I need to look up "certain critera" within a string of characters, then
return that "certain criterea" to a new column. Some examples of a strings of characters may look like these: K5J091509001 Sample PO#S881009 K55sample PO CarrieRJR TJ5 My "Certain Critera" I have listed on another sheet, named "REP ID" K5J S88 K55 RJR TJ5 How do I pull out the 3 characters of "Certain Criterea" from the string of text and copy or enter it into a new column? It's never consistant. This is the problem I'm having! Sales Reps enter their 3 character id with a bunch of other junk as a reference. I just need their 3 letter Id pulled out to do a vlookup with that information. like RepID K5J could be nested anywhere within a string of text 12/10/09K5J PO# K5J121009001 121009001K5J Sample PO#K5J KenREPIDK5J1210 and I have 100's of REP ID's listed on another sheet. Anyone??? Please...... Thanks!!! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup text in a string with wildcard and return a certain value | Excel Worksheet Functions | |||
lookup a value within a text string | Excel Worksheet Functions | |||
lookup or find matching number in text string | Excel Worksheet Functions | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) |