Function for "Contains"

[Andrew Mackenzie]

Hi all,

Hopefully someone can tell me what function I should use to determins
whether a cell contains the text "(FX)" to be used in an IF statement. E.g.

In cell A1 I have "ABC Corporation (FX)", in cell A2 I have "ABC
Corporation" and in Cell A3 I have "ABC (FX) Corporation". In cells B1 to
B3 I want a formula that returns TRUE in B1 and B3 and FALSE in B2.

Thanks in advance.

Cheers,

Andrew

 

[Andrew Mackenzie]

Perfect Mike - Thanks a million!

Hi,

In B1 and drag down

=NOT(ISERROR(SEARCH("FX",A1)))

Mike

 

[Mike H]

Hi,

In B1 and drag down

=NOT(ISERROR(SEARCH("FX",A1)))

Mike

 

[Mike H]

Did you want to check for parenthesis as well

=NOT(ISERROR(SEARCH("(FX)",A1)))

Mike

 

[Mike H]

and another

=ISNUMBER(SEARCH("(FX)",A1))

Mike

Did you want to check for parenthesis as well

=NOT(ISERROR(SEARCH("(FX)",A1)))

Mike

 

[Jarek Kujawa]

=IF(ISERROR(FIND("(FX)",A1,)),FALSE,TRUE)

then copy