Cell contains

[ch1]

Hope you can help

I need to check if a cell contains certain charaters and input yes in another cell.
Problem is the characters could be anywhere in the cell

eg.

A1 could have a name David Smith or D Dmith or Mr D Smith

I want to have cell B7 say 'YES' if cell a1 contains 'Smith'

any ideas

Thanks

 

[dk]

Hello,

Try this formula:-

=IF(ISERROR(SEARCH("Smith",A1)),"","YES")

 

[Sir Vili]

Hi ch1.

Test this formula also:

=IF(ISNUMBER(SEARCH("Smith",A1)),"YES","NO")

Regards Sir Vili.

 

[ch1]

Thanks to both of you for the help

Just the job

Great