Function for "Contains"
 

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

Function for "Contains"
 

Perfect Mike - Thanks a million!
"Mike H" wrote in message
...
Hi,

In B1 and drag down

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

Mike

"Andrew Mackenzie" wrote:

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

Function for "Contains"
 

Hi,

In B1 and drag down

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

Mike

"Andrew Mackenzie" wrote:

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

Function for "Contains"
 

Did you want to check for parenthesis as well

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

Mike

"Mike H" wrote:

Hi,

In B1 and drag down

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

Mike

"Andrew Mackenzie" wrote:

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

Function for "Contains"
 

and another

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

Mike

"Mike H" wrote:

Did you want to check for parenthesis as well

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

Mike

"Mike H" wrote:

Hi,

In B1 and drag down

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

Mike

"Andrew Mackenzie" wrote:

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

Function for "Contains"
 

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

then copy


On 6 Mar, 12:37, "Andrew Mackenzie" wrote:
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