Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to extract numbers out of a text string

  1. #1
    New Member
    Join Date
    Dec 2010
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to extract numbers out of a text string

    Hello,

    I have a text string that contains a social secuirty number and I want to extract it to a different column. Example:

    Text string: D4AX3TY05T123456789T
    I am trying to extract the SSN (underlined) and place it in a separate column. One thing about this text string is that the SSN starts at the 11th character and they all have a T at the end. Any help is appreciated.

    fewaldron

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,612
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract numbers out of a text string

    Sheet3

     BC
    2D4AX3TY05T123456789T123456789

    Spreadsheet Formulas
    CellFormula
    C2=MID(B2,11,9)


    Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.





  3. #3
    New Member
    Join Date
    Dec 2010
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to extract numbers out of a text string

    Thank you for your quick response...I have no idea why I was trying to use the MID, LEFT and FIND functions...

    that's why they always say K.I.S.S.

    Thanks again...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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