Because SEARCH returns a #VALUE error if the text is not found. Testing this
for > 0 still returns #VALUE, whereas testing it for a number, ISNUMBER,
will return FALSE, which is coerced correctly to a number.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dcd123" <dcd123.1u6m6m_1124741195.6834@excelforum-nospam.com> wrote in
message news:dcd123.1u6m6m_1124741195.6834@excelforum-nospam.com...
>
> Thank you. It did work! Can you explain why the ISNUMBER and SEARCH
> made the difference?
>
>
> --
> dcd123
> ------------------------------------------------------------------------
> dcd123's Profile:
http://www.excelforum.com/member.php...o&userid=25396
> View this thread: http://www.excelforum.com/showthread...hreadid=397880
>