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
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