about right,find functions

[curtisw]

I just want to show ST01,but why it still shows f, fo, for..etc in different cells with the same formula?

thanks

 

[jasonb75]

Right(len(a1)-etc..

equates to right(25-18) for the first entry.

25-18 = 7, there is no second argument for the RIGHT function so it defaults to 1 character, resulting in mid(a1,find("ST",a1,7)

St-01 f is 7 characters long.

Try

=IF(ISNUMBER(FIND("ST",A1)),MID(A1,FIND("ST",A1),FIND(" for",A1,FIND("ST",A1))-FIND("ST",A1)),"")

 

[Joe4]

I didn't add in all the error checks, but here is a formula that works for your examples. It finds ST, and then the first space after that in order to determine how much to pull:

=MID(A1,FIND("ST",A1),FIND(" ",A1,FIND("ST",A1))-FIND("ST",A1))

 

[curtisw]

these formula are work,thanks