Removing error code #VALUE! after using FIND

I am using FIND successfully to look for a particular name that may of may not be in a string containing many names.

If the name is found I get a number representing the position of the first letter of the particular name. I can easily change this yp yjhr rquired value 1.

If the name is not found I get "#VALUE!".

I want to get rid of the "#VALUE!" and leave the cell blank but it is obviously not stored as simple text.

Any ideas?

With Excel 2003 and earlier;
Nest your formula inside an IF and ISERRROR like so
IF(ISERROR(your formula),"",your formula)

Excel 2007 and later
Use IFERROR
=IFERROR(your formula,"")
Is that what you are looking for?

Originally Posted by ChemistB

Excel 2007 and later
Use IFERROR
=IFERROR(your formula,"")
Is that what you are looking for?

Thanks for the suggestion.

Ar present I am at my daughter's house si I will give it a try the midddle of next week.

Edit

I couldn'i wait so long so I sneaked upstairs and got the laptop out.

AND ............it worked a treat.

many thanks.