Trapping #VALUE! error
Here's one way:
=IF(ISERR(FIND("/",A1)),"",--MID(A1,1,FIND("/",A1)-1))
Or:
=IF(ISERR(FIND("/",A1)),"",--LEFT(A1,FIND("/",A1)-1))
--
Biff
Microsoft Excel MVP
"RhysPieces" wrote in message
...
I am using a MID function to extract numbers from a string:
=--MID(A1,1,FIND("/",A1)-1)
If the string does not contain "/", it results in the #VALUE! error.
What code needs to go in front of the formula to trap this and return ""?
Thank you for your replies.
|