Extract everything after a symbol and copy to adjacent cell

  • Re: Extract everything after a symbol and copy to adjacent cell


    If your data is simply a single column in A then you don't really need a macro. Just =RIGHT(A1,LEN(A1)-FIND("?",A1)) and Autofill it down column B (double click on the Autofill handle should make it easy).

    If you need them as values then after entering the formulas select Column B and then Copy, Paste Special > Values.

  • Re: Extract everything after a symbol and copy to adjacent cell


    Hi Rob and thanks. This works well but leaves the original text to be moved (after the symbol) in cell A1. I would really like to 'cut' it rather than copy it. My mistake in not making that clear. Also do you know how to remove numbers from the beginning of the string? Some numbers have numbers only, some are suffixed with a . and some suffixed by a )

  • Re: Extract everything after a symbol and copy to adjacent cell


    You can :
    B1=LEFT(A1,FIND("?",A1)-1)
    C1=RIGHT(A1,LEN(A1)-FIND("?",A1))

    And do what Rob told you above.

    On taking away the suffixed "." from some data, you can consider the following (assuming that A2 is the data):
    B2=IF(ISERR(FIND(".",A2)),A2,LEFT(A2,FIND(".",A2)-1)&RIGHT(A2,LEN(A2)-FIND(".",A2)))

    And follow the same copy and fill as told by Rob.

    Have a nice day!

    Yura