FIND for two strings

[frankee_gee]

Hello World - looking for help on the following excel formula. I would like to search for two (2) text strings, "RT" and "ST" in the FIND area.

This formula is what I'm currently using and for every "ST" I receive an error "#VALUE!"

=IF(RIGHT([@[ST_Supplier Part Number]],1)="N",
LEFT([@[ST_Supplier Part Number]],FIND("RT",[@[ST_Supplier Part Number]])-1)&"N",
LEFT([@[ST_Supplier Part Number]],FIND("RT",[@[ST_Supplier Part Number]])-1))

here's a pic of what I get in return in [column1]

return

INPC
INPCN
INPS
INPSN



Thank you for your help in advance.

Frankee

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	916FRTN	916FN
3	917FRT	917F
4	INPCST	INPC
5	INPCSTN	INPCN
Data

Cell Formulas
Range	Formula
B2:B5	B2	=LEFT(A2,MIN(IFERROR(FIND({"RT","ST"},A2),""))-1)&IF(RIGHT(A2)="N","N","")

 

[Tetra201]

Maybe just

=SUBSTITUTE(SUBSTITUTE([@[ST_Supplier Part Number]],"RT",""),"ST","")

 

[frankee_gee]

Perfect. Thank you so much...I always complicate things...nice and clean.