Great video! Steps are very clear and functioning without flaw. I’ve made a few puzzles and just curious to see if you have any tips for pasting the letters into the puzzle in other directions? Ie from the bottom up, backwards or on a diagonal? I’ve typed them into these angles but thought I’d ask you to see if you could suggest a simple function to use. Thanks 🙏
Very impressive! What I want to create is a word search, in which I provide a clue to each word to be included in the puzzle, rather than giving out the word itself. Is this covered by one of your excellent videos?
Hi, Graham. I haven't covered this in any of my tutorials, but I have a couple of ideas you can try. First, regardless of which you try, you'll still create the word search the same way. The main difference will be what you share in your final version. You'll still want to keep a copy with the answers for yourself. In one option, you could list the clues for each word in the same way as you would if they were the words to be searched (below the puzzle area). This way people can cross them out as they find them. Just make sure they're short and to the point. The other thing you could try is creating a puzzle with a theme. Type the theme or topic as the title. The words would then all be related to the title. Then, where the words to be searched would normally be (below the puzzle area), you could use an underscore (followed by a space) to symbolize the number of letters in each word. For example, if looking up the word GAME, you would display _ _ _ _ as the clue. You could do the underscore + space manually or, to make it go a little faster and avoid errors, you could use a formula like =REPT("_ ",LEN(A1)) where A1 would contain the answer. Then copy the result and use Paste Special / Paste Values, to place it below the puzzle as the clue. I hope this helps. Please let me know if you have other questions or ideas.
Thank you! That was really very clever, I especially liked your use of MID & COLUMNS to break the words up, I'd been doing it by using RIGHT and LEFT functions in individual cells, much more longwinded! I'm now trying to get Excel to automatically "hide" the words randomly (horizontally, vertically & diagonally) in the grid, any ideas?
Thank you. this was so helpful. However something happened and when I tried to paste it gives me all the first letter of the word how do I correct that? I was able to put some of the words in and then something changed. Maybe I’m not hitting the right buttons.
Hi, Diana. Something seems odd. Are you referring to when you tried to paste the words into the puzzle area? I'm wondering if you selected the word to paste into the puzzle, but then, just before copying it, accidentally selected only the first letter? Can you describe for me a little bit more what is happening up to that point? Thanks
Oh whoops! I made this before I had a 365 subscription. I’ll need to add it to my list and work on an updated version. Thanks so much and I’m happy this helped you 🙂
Hi, Julie, yes, there is! - for vertical and backwards. You can read the steps to do so in step 4 of this article: yacostasolutions.com/make-a-word-search-in-excel/ Thanks and hope this helps 🙂
Hi, Sheila. I would expect so. Excel has a function translator add-in that can help with translating the functions used in this. You can add it from the Insert tab, in the Add-ins section. appsource.microsoft.com/en-us/product/office/WA104381504?src=office&corrid=ce235916-15bd-427c-89da-3a516feac2ba&omexanonuid=2ccb6d6d-8e23-4bef-92f6-3b9a8c86605a&referralurl=
Hi, Ronald. Thanks for your feedback. I ran through this again, as a sanity check, and the comma between the 65 and the 90 is correct. It doesn't work for you? Thanks
I had to look more into it. I've never heard of this before! Apparently, it's a language setting. If you're interested in switching to using commas instead of semicolons, take a look at this link with steps on how to do it - at least for my computer, these steps worked. It might be worth a shot: lockone.wordpress.com/2015/08/06/excel-now-using-semicolons-instead-of-commas-in-separating-formulas-fix-it-now/
Hi, Bayou Art. I'm so sorry about the formulas! I found this list at easy-excel.com with a list of common Excel functions translated from English to French - easy-excel.com/excel-in-other-languages/excel-formulas-in-french/ It should contain the functions used in this tutorial. Please let me know if these don't work for you and I'll see how else I can try and help. Thanks!
Hi, Maggie. I'm sorry the video wasn't a good experience for you. And thanks for letting me know. Appreciate the feedback. I'll need to work on how to make future tutorials easier to see. Thanks
You can't hear it but thousands of teachers around the world are clapping for you :P
Thanks so much! This is one of the nicest feedbacks ever 😊
This is such a great tutorial. Thank you for explaining each step so carefully.
Thanks so much, Christina! I’m so glad you liked this 🙂
Thank you. You are amazing. Very easy to follow instructions. Thank you very much.
Thanks so much, John 🙂 I'm so happy you liked this!
Like this tutorial? Make sure to grab your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
Thus video is very good
Thanks so much, Abida 🙂
Had to rewatch, knew most of the function but in combination the output was awesome!
That's awesome! Thanks for sharing 🙂
Great video! Steps are very clear and functioning without flaw. I’ve made a few puzzles and just curious to see if you have any tips for pasting the letters into the puzzle in other directions? Ie from the bottom up, backwards or on a diagonal? I’ve typed them into these angles but thought I’d ask you to see if you could suggest a simple function to use. Thanks 🙏
Wow! I love it 😊👍
Thank you, Mazen! I'm happy you liked this 🙂
Thankyou so much🙂🙂
Thanks! I’m happy you liked this 🙂
Thank you so much!
Thanks, Rebecca! I’m happy you liked this 🙂
Wow! That was awesome! Thank you!
Thank you, Patricia! I'm excited you liked this 🙂
Great great. Thank you
Thank you 🙂 I’m happy you liked this!
Nice
Thanks so much! I’m happy you liked this tutorial 🙂
Thankyou very much for sharing your valuable knowledge... really very useful...
Thank you, srinu! I’m happy you liked this so much 🙂
Thanks you I will try it!
wow!!!! Amazing!
Thanks so much 🙂
This video was very very helpful. Thank you!!
Thank you, MrsGuppy 🙂 I hope your puzzle was a great success!
How neat! Thank you!
Thanks, Josie! I'm happy you liked it 🙂
Very nice! Thank you for the formula! I subscribed!
Awesome, Veronica! Happy to have you on board 🙂
Thanks - very useful
Thanks, Prasanna 🙂 I'm happy this was helpful for you.
Thank You!
Thank you, Nam Mô Phật! Happy you enjoyed the tutorial 🙂
Great video! Thanks 😊
Thanks so much, Oleandra! I'm glad you liked this 🙂
Thank you😊
Hi, Victoria. I'm happy you enjoyed it and thank you 🙂
Thank you very much. It really helped me in my project work. keep on making such videos.
I'm happy the tutorial was helpful and thank you for the kind words :)
Awesome. Thankyou
Thank you. That's sweet of you to say 🙂
Superb
Thanks so much, Vishal 🙂
wonderful.....
Thank you, Anil 🙂
Very impressive! What I want to create is a word search, in which I provide a clue to each word to be included in the puzzle, rather than giving out the word itself. Is this covered by one of your excellent videos?
Hi, Graham. I haven't covered this in any of my tutorials, but I have a couple of ideas you can try.
First, regardless of which you try, you'll still create the word search the same way. The main difference will be what you share in your final version. You'll still want to keep a copy with the answers for yourself.
In one option, you could list the clues for each word in the same way as you would if they were the words to be searched (below the puzzle area). This way people can cross them out as they find them. Just make sure they're short and to the point.
The other thing you could try is creating a puzzle with a theme. Type the theme or topic as the title. The words would then all be related to the title. Then, where the words to be searched would normally be (below the puzzle area), you could use an underscore (followed by a space) to symbolize the number of letters in each word. For example, if looking up the word GAME, you would display _ _ _ _ as the clue.
You could do the underscore + space manually or, to make it go a little faster and avoid errors, you could use a formula like =REPT("_ ",LEN(A1)) where A1 would contain the answer. Then copy the result and use Paste Special / Paste Values, to place it below the puzzle as the clue.
I hope this helps. Please let me know if you have other questions or ideas.
Awesome
Thank you, Praveen 🙂
=MID($K2, COLUMNS($K$2:K$2), 1) just to help me remember
Hi, Julia. Hope your wordsearch is a success! Also, don't forget, inside the formula you don't need to add a space after the commas.
Have fun!
Thank you! That was really very clever, I especially liked your use of MID & COLUMNS to break the words up, I'd been doing it by using RIGHT and LEFT functions in individual cells, much more longwinded! I'm now trying to get Excel to automatically "hide" the words randomly (horizontally, vertically & diagonally) in the grid, any ideas?
Did you have any luck figuring out how to do this? I am looking for a way to do that right now as well.
very cool.
Thanks!
Thank you. this was so helpful. However something happened and when I tried to paste it gives me all the first letter of the word how do I correct that? I was able to put some of the words in and then something changed. Maybe I’m not hitting the right buttons.
Hi, Diana. Something seems odd. Are you referring to when you tried to paste the words into the puzzle area? I'm wondering if you selected the word to paste into the puzzle, but then, just before copying it, accidentally selected only the first letter? Can you describe for me a little bit more what is happening up to that point? Thanks
Great video. A thing that isn't clear to me is: how can you "circle" words so you can also build solutions tables?
This is great, but in Excel 365 it works a bit differently. Otherwise, I was able to complete it. Thanks
Oh whoops! I made this before I had a 365 subscription. I’ll need to add it to my list and work on an updated version. Thanks so much and I’m happy this helped you 🙂
Is there any way to have the words upside down, backwards, or diagonal?
Hi, Julie, yes, there is! - for vertical and backwards. You can read the steps to do so in step 4 of this article: yacostasolutions.com/make-a-word-search-in-excel/
Thanks and hope this helps 🙂
Can we do this with other scripts like in Hindi?
Hi, Sheila. I would expect so. Excel has a function translator add-in that can help with translating the functions used in this. You can add it from the Insert tab, in the Add-ins section.
appsource.microsoft.com/en-us/product/office/WA104381504?src=office&corrid=ce235916-15bd-427c-89da-3a516feac2ba&omexanonuid=2ccb6d6d-8e23-4bef-92f6-3b9a8c86605a&referralurl=
You need to explain what you are typing as you type
error in your code should be
=CHAR(RANDBETWEEN(65;90))
Hi, Ronald. Thanks for your feedback. I ran through this again, as a sanity check, and the comma between the 65 and the 90 is correct. It doesn't work for you? Thanks
@@YAcostaSolutions Weird eh! I had to remove it and change it to ; for it to work with excel 365 on win 10. Doesn't surprise me one bit. MC
I had to look more into it. I've never heard of this before! Apparently, it's a language setting.
If you're interested in switching to using commas instead of semicolons, take a look at this link with steps on how to do it - at least for my computer, these steps worked. It might be worth a shot:
lockone.wordpress.com/2015/08/06/excel-now-using-semicolons-instead-of-commas-in-separating-formulas-fix-it-now/
the formula don' work with me my excell is in french how can i do please?
Hi, Bayou Art. I'm so sorry about the formulas! I found this list at easy-excel.com with a list of common Excel functions translated from English to French -
easy-excel.com/excel-in-other-languages/excel-formulas-in-french/
It should contain the functions used in this tutorial. Please let me know if these don't work for you and I'll see how else I can try and help. Thanks!
not a bad video but the camera was a bit far away and made it difficult to see what was happening
Hi, Maggie. I'm sorry the video wasn't a good experience for you. And thanks for letting me know. Appreciate the feedback. I'll need to work on how to make future tutorials easier to see. Thanks