+ Reply to Thread
Results 1 to 3 of 3

using a formula to remove all text before "T" in a Cell

  1. #1
    Forum Contributor
    Join Date
    06-25-2018
    Location
    South-Africa Pretoria
    MS-Off Ver
    2016
    Posts
    106

    using a formula to remove all text before "T" in a Cell

    Hi There

    Please assist me in the below.

    I use to be able to make use of the =Substitute formula but cant seem to find anything on google.

    29 BIRD ST T17198
    42ND HILL ATL T19459
    ACACIAVILLE POWER T10371
    ACCACIAVALE VC T10414
    ALLEN STREET VC T5953
    ALLWEAR INDUSTRIAL T3674

    All the above lines is in its own cell, Now I want to extract all the "T" which is connected to the numbers.

    So my results should be

    T17198
    T19459
    T10371
    T10414
    T5953
    T3674

    i keep on thinking it was something like

    Please Login or Register  to view this content.
    But it does not work.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    10,332

    Re: using a formula to remove all text before "T" in a Cell

    maybe:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    26,284

    Re: using a formula to remove all text before "T" in a Cell

    How about this?

    =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),50))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1