You're welcome!.


"Norman K via OfficeKB.com" wrote in message
...
Thanks KK it works

Regards

Norman
kk wrote:
Hi Norman

Try...

=IF(ISNUMBER(SEARCH("test",A30,1)),"Yes","No")



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200509/1