View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

Numbers to the left of the"x":
=LEFT(A1,SEARCH("x",A1)-1)*1

Numbers to the right of the "x":
=MID(A1,SEARCH("x",A1)+1,15)*1

I hope that helps.

--
Regards,
Ron