View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way

=MID(A1,13,19-13)

Regards,

Peo Sjoblom

"carl" wrote:

I have data that looks like so:

70AI200412021317000848

is there a formula that will pull out only the data that is in position 13
thru 19 ?

Thank you in advance