Thread: #Value! error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HalB HalB is offline
external usenet poster
  
Posts: 6
Default #Value! error
Voila!

Thanks!


Ragdyer wrote:
Try this:

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

Reply With QuoteReply With Quote