Thread: Extract using MID function ?
View Single Post
  #7   Report Post  
Emory Richter
 
Posts: n/a
Default
In article ,
says...
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)

ragdyer
Thanks for the alternate possibilities.
Emory
Reply With QuoteReply With Quote