Looking for a formula to find if there is a text plus number combination

Hello,

I need to look through cells in a column and mark them as true if they have the combination of "FR " or "FR" followed by 5 numbers. E.g. FR12345 or FR 12345. The "FR" related combination can be anywhere in a text string in the cell. Can someone help share a formula that would be able to mark "True" if this combination is found?

Thanks.

Assuming starting in A2, try:

=ISNUMBER(MID(SUBSTITUTE(A2," ",""),SEARCH("FR",SUBSTITUTE(A2," ",""))+2,5)+0)

copied down.

It worked like a charm! Thanks a million!

Awesome!!! :wof: