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?