I've only recently found this forum and have found it wonderfully helpful.
I'm trying to extract text from the following string:
%B6100569849384652^GRAHAM/DAVID EXAMPLE ^180579911965022VNDAVID
The first thing I would like to do is extract the 8 digits (birthday) after the 8 digits after the 2nd ^ (the digits I have highlighted in green).
The second thing I would like to do is extract the 2 letters after the green numbers (highlighted in blue)
So far with the help of this forum I have figured how to extract the name and the 10 digits to the left of the first ^,but now I'm stumped. Thanks to all.
Excel version 2010.
I'm trying to extract text from the following string:
%B6100569849384652^GRAHAM/DAVID EXAMPLE ^180579911965022VNDAVID
The first thing I would like to do is extract the 8 digits (birthday) after the 8 digits after the 2nd ^ (the digits I have highlighted in green).
The second thing I would like to do is extract the 2 letters after the green numbers (highlighted in blue)
So far with the help of this forum I have figured how to extract the name and the 10 digits to the left of the first ^,but now I'm stumped. Thanks to all.
Excel version 2010.
Last edited: