[SOLVED] How to reorder randomly words in multiple rows?

peter_yt · Newbie Joined: 23 Oct 2011 Posts: 3

I want to reorder/shuffle words randomly in multiple rows but it only shuffles the words in the first row. I am still new with open office so i need help how to do this for all rows. This is what i am doing: I select the rows and then i choose data>sort. Then in the options i choose "left to right (sort column)" but it shuffles only the words in the first row.

I uploaded one example file if someone wants to check it.

http://www.mediafire.com/?7k5whsix8vbadsn

Thanks!

floris_v · Posted: Sun Oct 23, 2011 12:33 pm Post subject:

It did shuffle words in all rows for me in LibreOffice. What version of OOo did you try it with?
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum

peter_yt · Newbie Joined: 23 Oct 2011 Posts: 3

I found how to shuffle the words but now how i can join them?

This is what i want to do. I am pasting in spreadsheet in A column 100 sentences that have a different number of words in them. Then i am using "text to column" and separating the words in these sentences using "space" as a delimiter. Then i shuffle the words. And now i want to join the words in sentences again. How can i do this?

I am using the last version of open office 3.3.0

Thanks!

ken johnson · Posted: Tue Oct 25, 2011 4:04 am Post subject:

Attached doc (Reorder Sentence.ods) uses formulae to shuffle the words after Text to Columns, and formulae on Sheet2 to form jumbled sentences.
http://www.mediafire.com/view/?de3reiq57dabm73
Formulae in Sheet1.A110:AX209 return either random number or blank depending on number of words in sentence in column A (rows 1 to 100)

Formulae in Sheet1.A212:AX311 reorder the words.
Formulae in Sheet2.A1:AX100 reassemble the word into a jumbled sentence.
On Sheet2 columns A to AW are hidden.

Since only columns A to AX (50 columns) have been used, this setup has a limit of 50 words per sentence.
For more than 50 word per sentence the formulae in Sheet1AX110:AX209, Sheet1.AX212:AX311 and Sheet2.AX1:AX100 will all need to be filled across their respective sheets for extra columns.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

peter_yt · Newbie Joined: 23 Oct 2011 Posts: 3

Thanks!