search for sub string

[Geezer34]

Hi guys,

I have a column with text that can contain a number of words one of which is 'UK & Europe'.

I want to have another cell which will contain the value EMEA if the the cell mentioned above contains the word UK.

Any ideas how to do this as I'm stumped... I get a #value in cells that dont contain the word when using the formula

=IF(FIND("UK",H27),"EMEA","ROW")

Thanks

[sweep]

Hi,

Find produces an error if there is no match, so,

=IF(ISERROR(FIND("UK",H27)),"ROW","EMEA")

should work

[broro183]

you are close, try

Please Login or Register  to view this content.

hth
Rob

[Geezer34]

Thanks guys - all seems to work on this one...

[broro183]

Thanks for the feedback - I'm pleased we could help

Rob