#Value! error
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.
|