You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"RhysPieces" wrote in message
...
The solutions from T. Valko and Peo Sjoblom work equally well. Thanks to
both
for prompt replies.

"T. Valko" wrote:

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.