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…

Need to split cell info based on text start and end points

ppr (Peter Preuss) March 16, 2022, 4:57pm 2

We can do with e.g. with regex

EVIDENCE(.|\n)*?(?=WORKAROUND)

Topic		Replies	Views
Hi folks need a help Help	7	829	January 15, 2020
Need help in excel column split Activities excel , activities , question	8	863	July 28, 2022
Read specific text and write into next column Activities excel , activities , question	4	566	June 12, 2022
Split data using regex Studio studio , question , designer_canvas	2	411	March 10, 2023
How to split the long string into each word then copy/paste into each column in excel file when we use the regex pattern (Matches) Help	3	1371	March 25, 2019