| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| formula to determine the first column containing any data | Excel Worksheet Functions | |||
Hybrid Mode
