One word of note:

Your original formula, and the one I suggested, which was built around it,
is *case sensitive*!

If the "DR." may be "dr." in some of your data, you would need a more robust
formula.

You might use this instead of my original suggestion, since it would work
for all situations:

=IF(ISERR(SEARCH("DR.",A1)),A1,SUBSTITUTE(UPPER(A1 ),"DR.","DOOR"))

Appreciate the feed-back.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"HalB" wrote in message
...
Voila!

Thanks!


Ragdyer wrote:
Try this:

=IF(ISERR(FIND("DR.",A1,1)),A1,SUBSTITUTE(A1,"DR." ,"DOOR"))