I have text data that I want to parse. The data is split into cells but each cell contains more that just one sentence. I want to isolate the sentences into individual cells to make parsing easier.
I used the formula below to count sentences in a given cell and it works well, so I'd assume ". " can be used to demarcate sentences.
So now I would like to split the content of these cells containing text, and copy each sentences (separately, in their own cell) to a row on a different sheet. Each row would correspond to one text cell in the previous sheet.
Any idea of how I should proceed? Thank you!