Thread
:
Extract using MID function ?
View Single Post
#
3
Ron Coderre
Posts: n/a
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
Reply With Quote