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 IDCRM 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 [
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 IDCRM 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 [