Everything before the x:
=--LEFT(A1,SEARCH("x",A1,1)-1)

Everything after the x:
=--MID(A1,SEARCH("x",A1,1)+1,255)

=left() and =mid() both return strings. If you want to use those values as
numbers, you can convert them by using -- in front of the expression.

=search() and =find() are very similar functions. =Find() is case sensitive.
=search() is not.

Emory Richter wrote:

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

--

Dave Peterson