On Sat, 8 Apr 2006 05:04:02 -0700, Hardip
wrote:

Ron

Many thanks for that - it worked.

Can you please explain the ISNUMMBER element of the function? Might as well
truely understand how this works :-)

Many thanks again,
H


You're welcome.

If FIND succeeds, it returns a number indicating the position of the found
string. So the ISNUMBER is a test for success of the FIND worksheet function.

If FIND does not succeed, it returns a #VALUE! error value, so you could also
use the ISERR, ISERROR, or ERROR.TYPE functions to test for failure of the
function.

You should also note that the FIND worksheet function is case-sensitive. For a
case-insensitive function, you can use the SEARCH function, which will also
accept wild-cards.
--ron