Is it possible to shuffle/reorder words randomly in a row? If i want to reorder randomly the words in the example .xlsx file how can i do this?
Thanks!
Is it possible to shuffle/reorder words randomly in a row? If i want to reorder randomly the words in the example .xlsx file how can i do this?
Thanks!
Last edited by emil9216; 10-24-2011 at 07:25 AM.
See if this workbook helps.
Put any value in a blank cell to force a calculation.
Delete that entry to shuffle again.
Last edited by Marcol; 10-23-2011 at 07:26 AM. Reason: Split Worksheet to two sheets.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks, but if i have more rows with words, with different length that i want to shuffle, like in the example2.xlsx file is it possible the randomized words to appear on the right side?
Thanks!
That's a bit more tricky, this workbook will shuffle up to 12 cells in a row.
If you have more than 12 cells in any row you should be able to stretch the tables "Random Numbers", "Rankings", "Cell Count", and "Column to Return" to suit your needs.
Hope this helps
Thanks, it works.
One more question. If i try to merge all the rows from the example2.xlsx file it merges them in one single line and i want to merge the words from each row separately. Is it possible to do this with the merge function? Or is there a formula that can i use for combining a big number of columns?
I don't know what you mean by
Do you mean CONCATENATE()?Is it possible to do this with the merge function?
If so you might need this UDF ConcRange()
See the two attached files
With merge function i mean in the home tab there is a button "merge & center" but it is for combining the words from all rows in one sentence. It is not what i need.
Thanks, for the formula ConcRange(). I will use it.
What i am trying to do is, for example, to paste 100 sentences in column A, then using "text to column" to separate the words in the sentences with the "space" delimiter". Then shuffle the words and joining them again in sentences. I found that i can do this faster with open office because it has an option to sort horizontally, but i will probably use excel because i have a problem with the formats in which open office safes the files.
Last edited by emil9216; 10-24-2011 at 07:27 AM.
The feature "merge & center" will not combine (concatenate) words/numbers from multiple cells.
It will only return what is in the first cell of the range and then merge the cells into one visuaully physical cell.
My advice would be to forget that this feature exists, it causes more problems than it's worth.
P.S.
Download the file for ConcRange() there are several worked example of its' use.
Last edited by Marcol; 10-24-2011 at 07:42 AM.
In Reply to your PM
You need to copy the VBa Function from "UDF Concatenate Range (ConcRange).xls" to your workbook.
To use this you need to do this.
1/. In Excel, with your workbook open, press Alt+f11 this will take you to the VBa Editor.
2/. With the "Insert" Tab choose "Module"
3/. In the resulting window paste all of the following code
4/. Save the file and close the VBa Editor.Please Login or Register to view this content.
Thanks! This formula is what i needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks