Hello
I need help with a macro which creates random sentences out of a list of words (I have a column with 2000 rows. Each cell contains 50-60 words). In each cell, I would like to create sentences - without meaning - for example one sentence contains 4 words, the next one 8, the next one 5...
Basically the words should be separated randomly by a dot, and after each dot the next word has to begin with a capital letter.
I want to create sentences only in that cell (between 7 - 15 words per sentence). The words are separated by spaces and comas (word1, word2,... ). I would like to remove the comas.
Let's say these are the words from the first cell:
word1, word2, word3, word4, word5, word6, word 7, word8, word9, word10, word11, word12, word13, word14
After I run the macro, I would like the cell to look like this:
Word1 word2 word3 word4 word5 word6. Word 7 word8 word9. Word10 word11 word12 word13 word14.
The dots should change the place randomly. If I run the macro again then I should have a new set of sentences:
Word1 word2 word3 word4 word5 word6 word 7 word8 word9. Word10 word11 word12 word13 word14.
and so on.
This thing should happen for each cell from the column. I don't want the cells to be identical. Let's say that after I run the macro, I would like to have 5 sentences in the first cell, in the second cell 10 sentences, in the third cell 13 sentences, in the fourth cell 8 sentences... as randomly as possible.
Any assistance you could provide would be really appreciated.
Kind Regards
I need help with a macro which creates random sentences out of a list of words (I have a column with 2000 rows. Each cell contains 50-60 words). In each cell, I would like to create sentences - without meaning - for example one sentence contains 4 words, the next one 8, the next one 5...
Basically the words should be separated randomly by a dot, and after each dot the next word has to begin with a capital letter.
I want to create sentences only in that cell (between 7 - 15 words per sentence). The words are separated by spaces and comas (word1, word2,... ). I would like to remove the comas.
Let's say these are the words from the first cell:
word1, word2, word3, word4, word5, word6, word 7, word8, word9, word10, word11, word12, word13, word14
After I run the macro, I would like the cell to look like this:
Word1 word2 word3 word4 word5 word6. Word 7 word8 word9. Word10 word11 word12 word13 word14.
The dots should change the place randomly. If I run the macro again then I should have a new set of sentences:
Word1 word2 word3 word4 word5 word6 word 7 word8 word9. Word10 word11 word12 word13 word14.
and so on.
This thing should happen for each cell from the column. I don't want the cells to be identical. Let's say that after I run the macro, I would like to have 5 sentences in the first cell, in the second cell 10 sentences, in the third cell 13 sentences, in the fourth cell 8 sentences... as randomly as possible.
Any assistance you could provide would be really appreciated.
Kind Regards