Royal96
Power Member
- Mar 16, 2019
- 683
- 376
Here's what I'm trying to achieve:
I have scraped a bunch of content and now I want to extract long tail keywords (questions) from it.
To do that I planned to:
1. Split the text in A1 into rows, separated by "." AND "?" AND "!" so that I have 1 sentence in each row.
2. Filter/Sort rows containing "?"
3. Filter/Sort rows containing "keyword"
Now, for this I have found this formula:
=transpose(split(A1,"."&"?"&"!"))
The problem is that the delimiters "." AND "?" AND "!" get removed, so I can't extract the question keywords in the next step.
Do you know how to keep the delimiters while splitting the text?
I have scraped a bunch of content and now I want to extract long tail keywords (questions) from it.
To do that I planned to:
1. Split the text in A1 into rows, separated by "." AND "?" AND "!" so that I have 1 sentence in each row.
2. Filter/Sort rows containing "?"
3. Filter/Sort rows containing "keyword"
Now, for this I have found this formula:
=transpose(split(A1,"."&"?"&"!"))
The problem is that the delimiters "." AND "?" AND "!" get removed, so I can't extract the question keywords in the next step.
Do you know how to keep the delimiters while splitting the text?