Contains Function
 

Use Find instead.

FIND("Text to Find", "Text to Search", Start Position)

=if(ISERROR(FIND("Golf",A1,1),"","*")
--
Kevin Backmann

"contains" function
 

I like this approach....

For a value in A1

B1: =IF(COUNTIF(A1,"*golf*"),"*","")

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=529261