If, Contains

[Tracey]

Hello,

I have a column which contains names of Cities...
eg: cell a1= Tokyo, Hong Kong, New York
cell a2= London, Amsterdam, berlin
cell a3= London, Tokyo, New York, Madrid

is there a formula that will be able to pull out Tokyo

I was thinking of an IF statement: =IF(cell contains "Tokyo", "Tokyo", " ")
not sure how to go forward without going down the filtering route as it's a
huge spreadsheet and time is quite critical in reporting season.

many thanks

 

[edvwvw via OfficeKB.com]

=AND(FIND("Tokyo",A1))

The result will be TRUE if Tokyo is in the cell

edvwvw

 

[Bob Phillips]

=IF(ISNUMBER(SEARCH("tokyo,A1)),"Found","Not found")

 

[Bob Phillips]

Sorry, missed an apostrophe

=IF(ISNUMBER(SEARCH("tokyo",A1)),"Found","Not found")