How to remove words from a column that occur before a certain phraseI have a column with a variable number of words. Somewhere inside each row the phrase "my name is Spot" occurs. How can I remove all of the text that occurs prior to this phrase?
macOS