View Single Post
  #1   Report Post  
Emory Richter
 
Posts: n/a
Default Extract using MID function ?

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