How do I seperate numbers?
 

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

How do I seperate numbers?
 

Given the example, surely you can figure this out yourself.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

How do I seperate numbers?
 

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

"Don Guillett" wrote:

Given the example, surely you can figure this out yourself.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

How do I seperate numbers?
 

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

How do I seperate numbers?
 

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

How do I seperate numbers?
 

Also have a look at LEN and MID
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AJSloss" wrote in message
...
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

"Don Guillett" wrote:

Given the example, surely you can figure this out yourself.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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