Parsing Data w/ a Formula (another question)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Reading responses to your earlier question would introduce you to the MID
function (documented within Excel) which would be used here, with "start
number" 13 and "number of characters" equal to 19-13 = 6.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing Question 7
Excel Help to copy information from one row at a time to another sheet 1
SUMIF formula using data from another file 2
If statement linking data from one sheet to another 3
retrieving current data 1
FIND from right to left instead of left to right 8
Retrieve Column Header for Specific Data in a Row 3
Referring to a cell by using another cell for the row number 6

Back
Top