Results 1 to 6 of 6

Thread: Extract account numbers from a string of alphanumeric text

  1. #1

    Extract account numbers from a string of alphanumeric text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 [

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    That is all in one cell?


  3. #3
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    719
    Articles
    0
    Excel Version
    Excel 2010 64bit

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    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.


  5. #5
    Quote Originally Posted by NBVC View Post
    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.

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •