lookup text within string of text???

S

SaraMack

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!!! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pulling certain characters from a string of text 3
Find date in excel string previous to last occurence of specific text 14
Pullng data out of string of text 4
Split text string using mid-search? 3
Bold items within text string 7
Cut the last 20 characters out of a text string 4
Extract from the beginning of a text string 3
Formula to return a value for a portion of a text string in a cell 2

Top