"contains" function
 

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