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" wrote in
message ...
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