Find text in a string & copy to the end & paste in new column

  • Hi all -


    I'm trying to do the following.


    Look in a test string in column A "(The blue jean company in Column N)" and find the word "column."


    Once the word "column" is found copy the word column and the remaining text into another cell.


    For example the output should be "Column N" in the new cell.


    Is something like this possible?

  • Re: Find text in a string & copy to the end & paste in new column


    Do you mean?


    [COLOR="#0000FF"]=IFERROR(MID(A2,SEARCH("Column",A2),255),"")[/COLOR]


    The IFERROR() returns a blank if the word is not found.


    You can replace the "Column" with a cell reference containing the search word.


    You can also replace SEARCH with FIND if you want it to be a case-sensitive search.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Find text in a string & copy to the end & paste in new column




    Ah, yes! Brilliant.


    Thanks for the help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!