Thread: #Value! error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HalB HalB is offline
external usenet poster
 
Posts: 6
Default #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