+ Reply to Thread
Results 1 to 6 of 6

[Solved] Removing numbers and space before text

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    3

    Cool [Solved] Removing numbers and space before text

    How can I remove the numbers and space before the text?

    For example:

    1 ABAD, NASSER NARCISO
    2 ABAPO, REY CLINT REDILLAS
    3 ABAYAN, CHARISSE HONRADO
    4 ABAŅO, JEFFREY AQUINO
    5 ABELLO, CHITO LEONIDO
    6 ABLAY, NERIEGRACE NIDEA
    7 ABRIL, AGNES GAY ALIGAM
    8 ACERDEN, JUSTINE ANN RECEDE
    9 ADRIANO, BEE JAY HALOG
    10 ADUCA, ARNOLD DEL ROSARIO
    11 ADUNA, ERIC JOHN MILLER
    12 AGAYON, ALFRED MARK RODRIGUEZ
    13 AGSAWA, RYAN-JAY RICAMORA
    14 AGUA, SALVADOR ZABALLA
    15 AGUILA, CLARENCE JASPER CHANG
    16 AGUILAR, JERICH REYES
    17 AGUILAR, JEROME REYES
    18 AGUILAR, MYLENE MULDONG
    19 AGUILLON, PAUL SANTOS
    20 AGUINALDO, MARLON RAMOS

    There will be hundreds or thousands of rows which will be pasted to the first column.

    Your help will be very much appreciated. Thanks in advance!
    Last edited by loyski; 02-07-2012 at 11:42 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Removing numbers and space before text

    in B1
    =RIGHT(A1,LEN(A1)-FIND(" ",A1))

    and paste down
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Removing numbers and space before text

    Try this:
    =MID(A1,FIND(" ",A1)+1,256)
    Quang PT

  4. #4
    Registered User
    Join Date
    02-07-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Removing numbers and space before text

    Hello Special-K and bebo021999,

    I tried your suggestions but only the first entry was fixed. I want all entries from 1 to 822 (for example) to be fixed all at once. Or maybe I missed a step?

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Removing numbers and space before text

    Copy B1 and paste down till B822.
    Does it work?

  6. #6
    Registered User
    Join Date
    02-07-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Removing numbers and space before text

    Quote Originally Posted by bebo021999 View Post
    Copy B1 and paste down till B822.
    Does it work?
    Yes, it worked. I have to drag the cursor down to the bottom. Thanks! Problem solved!

+ 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