I am hoping someone can help me with splitting text from 1 cell into 3 different cells.
On the attached spreadsheet, I need to copy text from each cell in column H and split it into the below. pasting the output into columns I, J and K.
- Everything from the word Evidence down to (but not including) the word Workaround
- Everything from the word Workaround down to (but not including) the word Root
- Everything from the word Root down to the end of the text in that cell
Test.xlsx (10.9 KB)