How to create random sentences out of a list of words

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.

Any assistance you could provide would be really appreciated.

Kind Regards

Hi

if you have 50-60 words in a cell, do you want to create a sentence from the words within that cell, or from any cell in the 2000 rows?
and, are the words in the cells separated by spaces, comas, dots, or something else?

cheers
Nicky

Hi
this user-defined function will create a random list of 1 to 11 words from the contents of the target cell. It assumes the words in the target cell are separated by spaces.

Please Login or Register  to view this content.

Hi Nicky

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.

Thank very much.

Unfortunately I don't have much experience using VBA so if you could give me more details, that would be great. Thank you.

Also: www.ozgrid.com/forum/showthread.php?t=184261

Hi Morach
try this macro
it creates random numbers of 'sentences' within all the selected cells

Please Login or Register  to view this content.

Hi Nicky

I've just tested the macro and it works great Thank you very much for your help.

Have a nice day!