=MID(A1,FIND("FF",A1)-1,1)
Regards,
Stefi

€žKK€� ezt Ã*rta:

123FF+,456 ,789FF+ (Text format )

How can i find the "FF" and return the number before "FF" ?I had try to use
Find method in excel, but it only can help me to find out first "FF".