How to Create a Word Jumble in Excel / Make a Word Scramble in Excel - Tutorial
Vložit
- čas přidán 21. 08. 2024
- Create a Word Jumble in Excel! Excel tutorial on how to scramble letters in words to quickly make a fun word jumble game in Excel. Easy to learn how to create a word scramble in a spreadsheet.
In the word jumble example in this video, we walk through how to separate text inside Excel cells.
We then use the RAND function to help us mix up letters!
It's easy enough for Excel beginners to learn how to make a word jumble in Microsoft Excel by following the example.
A word jumble or word scramble is a great game for kids, the classroom, office party, birthday, bridal shower and any other special event. Plus, you can customize it by formatting it however you prefer. And you can make it using just a spreadsheet.
The steps we walk through in this example are also useful for other work or school tasks where you need to know how to mix up text in Excel or know how to separate text in cells.
Click here if you would like to read our step by step article on this: yacostasolutio...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutio...
*************************************
For other DIY games you can make in Microsoft Excel, take a look at these other video tutorials:
- How to Create a Word Search Puzzle in Excel - Tutorial: • How to Create a Word S...
- How to Create a Bingo Board in Excel - Tutorial: • How to Create a Bingo ...
- How to Create a Crossword Puzzle in Excel - Tutorial:
• How to Create a Crossw...
For more how to use Excel random formulas, take a look at this tutorial:
- How to Generate Random Numbers in Excel Using RAND, RANDBETWEEN Excel functions - Tutorial:
• How to Generate Random...
and
For more on ways to sort in Excel, watch our tutorial on doing a custom sort:
How to Custom Sort in Excel - Tutorial:
• How to Custom Sort in ...
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutio...
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutio...
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutio...
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
Like this tutorial? Make sure to grab your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
Thank you very much. This makes my task a lot easier and quicker.
Thanks, Christine! And congrats on tackling your task 🏆
Thank so much dear ...u made my job much easier 🙏🙏
That's great! I'm happy this helped you 🙂
Excellent!! Thank you for sharing!
Thank you, MrsGuppy! I’m excited you’re enjoying these 🙂
Thanks alot👍
Thanks so much, Kima! I’m happy you liked this 🙂
Very nice video. It gave me ideas for some new kind of content for my website. Thank you for sharing it. 😊 You have a nice way of explaining things.
Thank you, Bianca. And best of luck and success with your website!
@@YAcostaSolutions Thank you. 😊
super thanks
Thanks, Adhap! Happy you enjoyed this 🙂
Good prsentation, please guide for converting jumbled into possible combinations? regards
Hi, rp soni. What type of combinations are you thinking of?
@@YAcostaSolutions Madam, Thanks a lot again for so prompt attention,
Ex learx,
it is a jumbled word,
We need to get possible combinations using these 5 letters?
Possible Combinations must appear in a target range
Regards
I didn't understand how you did the RAND formulq
Hi, Nathan. The RAND function, because it refreshes and displays a new value each time an action happens on the sheet, you can use it to sort the letters in random order. Here's how:
Most of the time we sort data in columns (up and down), but, here, we're sorting the values from the RAND function from smallest to largest, but doing it left to right. By sorting the letters along with the values of the RAND function, they too move each time the values get sorted. This results in a "scrambling" or "jumbling" of the letters in each word.
I suppose you can always scramble the letters manually, but this is faster. And, when you're done, just delete the RAND function.
I hope this helps. Please let me know if you still have questions. Thanks!
Griheh
Love it! Thanks 🙂
hello
ate pano yun
Nagawa ko pero Hindi ko alam Kung pano mag function ito para malaro
Superb. Thank you.
Can you go further ?
I would like to extrapolate downwards every possible letter alignment that could be achieved from a single 7 letter word.
Internet Anagram solvers only provide known words with meanings. I want to see every Gobbldy Gook option, and choose from there.
With best wishes and thanks in advance,
Don.