That's exactly what I needed. Thanks Rick

"Rick Rothstein" wrote:

Try this...

=MID(A1,FIND("/",A1)+1,99)

--
Rick (MVP - Excel)


"AJSloss" wrote in message
...
This is a follow up to a previous question:

I have a web query which gives me the result "385/1700" and all I want is
the
first part "385" to allow me to do calculations with, but because it's a
web
query, it wont let me just format it as a fraction and times it by 1700..
it
comes up with the #VALUE! error.

So I dont know what else to try,
Can anyone help?

Thanks,
Aden
---------------------------------------------------
Answer:
=--(LEFT(A1,FIND("/",A1)-1))

--
HTH

Bob


My question is basically the same as the first, except I need the numbers
on
the right side of the "/" (the 1700).

Thanks,
Anthony