Try this instead.
=IF(ISNUMBER(SEARCH("Golf",B1,1)),"*","")
Your OP formula says to put an asterik if the search returns an error
so if it is not there then it will return the * but it shouldn't if it
is there.
Does that help?
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=529261