ExcelBanter - Parsing Data w/ a Formula (another question)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Parsing Data w/ a Formula (another question) (https://www.excelbanter.com/excel-worksheet-functions/7433-parsing-data-w-formula-another-question.html)

carl

Parsing Data w/ a Formula (another question)

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

Peo Sjoblom

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

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.

"carl" wrote in message
...
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

All times are GMT +1. The time now is 06:37 AM.