You're right Ron, my bad.........will have to put it on my list that I must
learn to read someday <G

Thanks for catching it.

Vaya con Dios,
Chuck, CABGx3



"Ron Rosenfeld" wrote:

Your second formula also extracts the terminal textual part of the string. The
OP only requested the numeric portion.

--ron

On Fri, 15 Sep 2006 04:34:01 -0700, CLR wrote:

Use these formulas in B1 and C1, copied down.........

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

Vaya con Dios,
Chuck, CABGx3



" wrote:

I have a cell containing for example:

Cell A1: -7 / +18 (%)
Cell A2: -4.5 / +3.5 (pts)

I want to break out the two values into separate cells, for example:
Cell A2 = -7, Cell B2 = 18
Cell A3 = -4.5, Cell B3 = 3.5

Can someone please tell me how?

Regards,

S



--ron