How to use IF &　FIND to find out diferent string in cell

Since I need to sort out difference codes (e.g. T01, T02, T03, T04, T05, T06, T07, T08, T09) in each cells, Ｉwrite formula =if(find("T01", B1), "T01", (find("T02", B1), "T02", (find("T03", B1), "T03", (find("T04",B1), "T04", "0")
It does not work. Please help to point out my problem, and suggest the correct formula. My Excel level is elementary. Thanks to all.

I guess that is what you were trying to do, although there most likely are better ways to do this

Please Login or Register  to view this content.

Originally Posted by Jdevil

I guess that is what you were trying to do, although there most likely are better ways to do this

Please Login or Register  to view this content.

Thanks, an excellence feedback !!!

Thanks, and an excellence suggestion.
Appreciated !

Originally Posted by AlKey

Here is another way
Enter all T0 in column D
Enter formula in C1 and copy down

Formula:

Please Login or Register  to view this content.

v	B	C	D
1	Text T03 and text	T03	T01
2	Text and T09text	T09	T02
3	Text T01 and text	T01	T03
4	Text TEXT and text T05	T05	T04
5	Text and T07text	T07	T05
6	Text T04 and text	T04	T06
7	Text Text and T08	T08	T07
8	Text T03 and text	T03	T08
9	Text T06 and text	T06	T09

Thanks, and an excellence suggestion.
Appreciated.

Or:

=LOOKUP(1,-FIND({" ","T01","T02","T03","T04","T05","T06","T07","T08","T09"}," "&B1),{"","T01","T02","T03","T04","T05","T06","T07","T08","T09"})

or
=IF(SUMPRODUCT(IFERROR(SEARCH({"T01","T02","T03","T04","T05","T06","T07","T08","T09"},A1),0)),A1,"")