Yeah. Right. As if you haven't thrown some egg yourself! You're just one of
the many I admire here, RD; one of the many who teach me new things all the
time. There are just some functions I can't get "on my list". SUBSTITUTE is
one of them. :)

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Ragdyer" wrote in message
...
Yellow complexion is from all the egg on my face.<vbg

Although still wouldn't hurt to use Upper().
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JE McGimpsey" wrote in message
...
No need to use FIND() at all - just use

=SUBSTITUTE(A1,"DR.","Door")

If "DR." doesn't exist, no error will be raised.

In article , HalB
wrote:

I am actually trying to replace "DR. " with "Door" but the error causes
the formula to fail.