Looks like you might have to use several formulas depending on the line/row
you are on.
Assuming your data begins in A2 and is consistant as you listed it you could
do something like this for each row and then copy/paste values into a new
sheet:

K5J091509001 =LEFT(A2,3)
Sample PO#S881009 =MID(A3,SEARCH("#",A3,1)+1,3)
K55sample PO =LEFT(A4,3)
CarrieRJR =RIGHT(A5,3)
TJ5 =TRIM(A6)


Hope that helps.

Frank


"SaraMack" wrote:

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?