For RIGHT of the "X":
=RIGHT(A1,LEN(A1)-SEARCH("X",A1))

For LEFT of the "X":
=LEFT(A1,SEARCH("x",A1)-1)

And if you want *real* numbers:
=--RIGHT(A1,LEN(A1)-SEARCH("X",A1))
=--LEFT(A1,SEARCH("x",A1)-1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Emory Richter" wrote in message
om...
I have cells with numbers of various character counts
seperated by an "x".

eg.
2x1.5
48x3

I can find the "x" position with the MID function.

Now how do I extract
ALL numbers to the right of the "x"
or
ALL numbers to the left of the "x" ?

Thank you,
Emory