close

Use Find instead.

FIND(quot;Text to Findquot;, quot;Text to Searchquot;, Start Position)

=if(ISERROR(FIND(quot;Golfquot;,A1,1),quot;quot;,quot;*quot;)
--
Kevin Backmann


I like this approach....

For a value in A1

B1: =IF(COUNTIF(A1,quot;*golf*quot;),quot;*quot;,quot;quot;)

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=529261

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄