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.