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

Quote from NBVC;720850

Do you mean?

=IFERROR(MID(A2,SEARCH("Column",A2),255),"")

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.

Display More

Ah, yes! Brilliant.

Thanks for the help