If, Contains
 

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

If, Contains
 

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

The result will be TRUE if Tokyo is in the cell

edvwvw

Tracey wrote:
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

--
Message posted via http://www.officekb.com

If, Contains
 

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

--
__________________________________
HTH

Bob

"Tracey" wrote in message
...
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

If, Contains
 

Sorry, missed an apostrophe

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


--
__________________________________
HTH

Bob

"Tracey" wrote in message
...
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