Bartt,

you can find details of the Excel SEARCH function in XL Help. It is
similar to FIND, but it is not case-sensitive and wildcards can be
used in the find_text parameter. You could use it like this:

=IF(ISNUMBER(SEARCH("FL:"&"*",IR3)),IR3,"")

Hope this helps.

Pete

On Oct 1, 6:43*pm, Bartt wrote:

I'm not entirely sure I follow, but...


First, I'm not aware of an Excel SEARCH() function. *You may mean the
FIND() function.