Parsing Data w/ a Formula (another question)

C

carl

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
 
D

Dave R.

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.
 

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
Consolidation Table from Different Excel Tabs with Different Format 1
Parsing 2
Extracting data from database into separate sheets 0
Newbie Help - IF Yes No Function 0
Need Help with a VBA subroutine 0
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
VLOOKUP Not working 3

Top