Hi,
I need help with deleting or splitting words using one word as a reference and deleting everything from this word. For example
Column C
I have worked at this desk
Never tried cooking at your house
What I want to do is to delete every single word that comes after "at", as all my rows will have the word "at" followed by different lines of text, so what I want it to be is either:
Column C
I have worked
Never tried cooking
Or splitting them like this:
Column C
I have worked
Never tried cooking
Column D
this desk
your house
Any help? Thanks!
Bookmarks