Extract account numbers from a string of alphanumeric text

joshdm0716

New member
Joined
Jan 24, 2014
Messages
3
Reaction score
0
Points
0
To All Excel MVP's i need your help.
Can anyone help me with a formula to extract numbers (account number) from a string of text that contains alphanumeric. the account number starts with 249,250,251 and TLC. Length for the 249,250 and 251 is 9; And for the TLC is 11. The 1st 3 characters of the account number are always in the same position and they do not appear in the others strings that are non account number. Any help is greatly appreciated. Thank you

Example. Assuming data is located in A1.

SERVICE REF: RELATED REF: ID: INS BK:XXXXXXX SER ID:pCRM SND BK: ID: 5ERANUA00000VBHJK303 249968059 91361 ID:001235737204 : ID: BVDFGR 20140703-00004704 VAL D D ORIG 250360150 GTHYKKK BNNNG 566840000078955* CORRECT BK 45366363 PCRM DIGGGI SERVICE [
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Thank you very much NoS.

Josh,

Please read the article attached to this link: Crossposting

You have quite a few people working on this. This is not fair to them, especially not knowing that you are madly posting your question at multiple forums. It is also not fair to other people asking questions as the potential responders are all busy with your thread.

Please make sure to post your links to all your threads. Please do this in all your threads, so that everyone knows.
 

joshdm0716

New member
Joined
Jan 24, 2014
Messages
3
Reaction score
0
Points
0
Thank you very much NoS.

Josh,

Please read the article attached to this link:
You have quite a few people working on this. This is not fair to them, especially not knowing that you are madly posting your question at multiple forums. It is also not fair to other people asking questions as the potential responders are all busy with your thread.

Please make sure to post your links to all your threads. Please do this in all your threads, so that everyone knows.


Thank you. Will comply going forward.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Have you posted all the links here?

Have you posted the link to this thread and others in those other forums you posted in?

This same Crossposting rule applies in all forums, and some forums will give you an infraction if they find out you've been crossposting without links.
 
Top