Hi there,

I've got a spreadsheet with sentences in it (one per row), and I need these sentences to be split as follows:
- copy the entire sentence (cell-content) into a new cell
- take the last word off the sentence and copy that new shorter sentence into the cell below the previous cell
- continue doing so until there's only the first word left
- then also copy the 2nd and 3rd word into individual cells below the previous ones.
- then go to the next sentence and keep adding the sentences into the cells in the same output column.

EXAMPLE:
INPUT:
(cell A1): "the lazy brown fox"
(cell A2): "jumps over the fence"
(cell A3): etc, simple sentences, the words separated by spaces.

Output:
B1: "the lazy brown fox"
B2: "the lazy brown"
B3: "the lazy"
B4: "the"
B5: "lazy" (these 2 cases are special cases: I want the 2nd and 3rd word individually, the previous lot was just making the sentence shorter and shorter. Note: if the sentence is only 1 or 2 words long, then obviously you cannot copy the 2nd or 3rd word!)
B6: "brown"
B7: "jumps over the fence"
B8: "jumps over the"
B9: "jumps over"
B10: "jumps"
B11: "over"
B12: "the"
etc etc etc
I have used column B as the output, but this is NOT mandatory, this could be a separate sheet inside the spreadsheet, whatever works easiest

The important thing is that after processing I have ONE column
where I have all variations (from full sentence, down to just the first word + 2nd and 3rd word)

Cheers

V.