#Value! error
How does one "overcome" the #Value! error when used in a function?
Example:
A1= "4 DR. SEDAN"
I want to FIND "DR."
The formula I use is =FIND("DR.",A1,1) and this works fine however when
A1 does not contain "DR." I get the error.
I am actually trying to replace "DR. " with "Door" but the error causes
the formula to fail.
Thanks
|