How do I seperate numbers?

A

AJSloss

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
Click to expand...
---------------------------------------------------
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
 
A

AJSloss

well, dick

i haven't been able to figure it out, otherwise i wouldn't have posted the
question. i tried substituting "right" for "left" and in some cases it works
and sometimes it doesn't based on how many digits are in the whole cell
 
Top