![]() In the opened dialog box, CLICK SORT OPTIONS.SELECT BOTH THE ROWS, LETTERS AND RANDOM NUMBERS After the random numbers have been generated, sort the numbers.įor sorting, select the random number cells, go to DATA TAB, click SORT.COPY THE NUMBERS, RIGHT CLICK AND PASTE AS VALUES Now, we need to freeze the Random word so select the letters, press CTRL+C to copy them and again RIGHT CLICK and choose PASTE SPECIAL as shown in the animation below. till G as shown in the picture below.ĭRAG THE FORMULA TO THE RIGHT TO GET RANDOM NUMBERS FOR ALL THE LETTERS Hold the small plus at the right bottom of the cell and drag it to the right till the last letter column of the separated word, i.e. It’ll create a random number in the cell.ENTER RAND() FUNCTION FOR THE FIRST LETTER Just in the next line to our newly separated letters, Enter the formula as =RAND().Whenever we want to create random choices, Excel provides us with RAND FUNCTION which will help us to randomize the letters.įOLLOW THE STEPS TO RANDOMIZE THE LETTERS FOR THE FINAL JUMBLED WORD STEP 2: REARRANGE THE LETTERS OF THE GIVEN WORDĪfter we have already separated the word, it is time to jumble them. ![]() COPY THE LETTERS, RIGHT-CLICK AND CHOOSE PASTE VALUES ONLY
0 Comments
Leave a Reply. |