Watchdawg72
New member
- Joined
- Jun 19, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I'm beginning to think this can't be done, but hopefully someone here has a solution...
I scan a tag and and this number is what populates excel: 01050002234203071724501101919B
from that number, the qualifiers are bold.
I need to extract the numbers between the "01" and "17" into one cell, between "17" and "10" in another, and those following the "10" in another.
Unfortunately there are two snags. The first set of numbers I need are either 13 or 14 digits long (no real rhyme or reason). Additionally, the "17" an "10" occasionally change places.
Is this even possible?:frusty:
I scan a tag and and this number is what populates excel: 01050002234203071724501101919B
from that number, the qualifiers are bold.
I need to extract the numbers between the "01" and "17" into one cell, between "17" and "10" in another, and those following the "10" in another.
Unfortunately there are two snags. The first set of numbers I need are either 13 or 14 digits long (no real rhyme or reason). Additionally, the "17" an "10" occasionally change places.
Is this even possible?:frusty: