Trapping #VALUE! error

[Guest]

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.

 

[Peo Sjoblom]

=IF(ISNUMBER(FIND("/",A1)),--MID(A1,1,FIND("/",A1)-1),A1)

 

[Guest]

=IF(ISERROR(MID(A1,1,FIND("/",A1)-1)),"")

 

[T. Valko]

Here's one way:

=IF(ISERR(FIND("/",A1)),"",--MID(A1,1,FIND("/",A1)-1))

Or:

=IF(ISERR(FIND("/",A1)),"",--LEFT(A1,FIND("/",A1)-1))

 

[Guest]

Disregard my answer--it won't work--sorry.

 

[Guest]

The solutions from T. Valko and Peo Sjoblom work equally well. Thanks to both
for prompt replies.

 

[T. Valko]

You're welcome. Thanks for the feedback!