Chris wants to generate Random Letters in a 26 x 26 Grid. Using the Ascii set of letters and a few tricks, Bill "MrExcel" Jelen shows us how to produce the grid in question. Follow along with Bill, in Episode #1698, as he goes through the 'how-to' on this topic and shows us the results.
And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Excel 2013 In Depth
"The Learn Excel from MrExcel Podcast Series"
Visit us: www.MrExcel.com for all of your Microsoft Excel Needs!
And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Excel 2013 In Depth
"The Learn Excel from MrExcel Podcast Series"
Visit us: www.MrExcel.com for all of your Microsoft Excel Needs!
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Learn Excel from MrExcel podcast, episode 1698 - Generate Random Letters!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question from Kris, Kris wants to generate a 26x26 grid of random letters, letters between A and Z.
So here's where we start: =CODE, the CODE of the letter A tells us the ASCII code of the letter A, it's 65.
And then the same thing, CODE of the letter Z is 90, 65-90.
So our goal is to generate random letters, characters between ASCII code 65 and ASCII code 90.
So I'm going to choose my whole big range of 26x26 here, and then =C-H-A-R!
What character we want?
We want 65 all the way up through 90.
So we're going to use another function, RANDBETWEEN!
RANDBETWEEN will give us the random number between 65 and 90, )) . There we go, I'm going to press Ctrl+Enter here to enter that same formula in all cells of the selection.
And we now have a 26x26 grid of random letters.
Every time we press the F9 key, we will get a new set of letters.
When we finally find a set that we like, we want to keep those, then of course Ctrl+C to copy, and then the right-click key, that's on the right hand side, between Alt and Ctrl, and V to convert those formulas to values.
There you go, 26x26 grid.
Alright well hey, I want to thank Kris for sending that question in, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Learn Excel from MrExcel podcast, episode 1698 - Generate Random Letters!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question from Kris, Kris wants to generate a 26x26 grid of random letters, letters between A and Z.
So here's where we start: =CODE, the CODE of the letter A tells us the ASCII code of the letter A, it's 65.
And then the same thing, CODE of the letter Z is 90, 65-90.
So our goal is to generate random letters, characters between ASCII code 65 and ASCII code 90.
So I'm going to choose my whole big range of 26x26 here, and then =C-H-A-R!
What character we want?
We want 65 all the way up through 90.
So we're going to use another function, RANDBETWEEN!
RANDBETWEEN will give us the random number between 65 and 90, )) . There we go, I'm going to press Ctrl+Enter here to enter that same formula in all cells of the selection.
And we now have a 26x26 grid of random letters.
Every time we press the F9 key, we will get a new set of letters.
When we finally find a set that we like, we want to keep those, then of course Ctrl+C to copy, and then the right-click key, that's on the right hand side, between Alt and Ctrl, and V to convert those formulas to values.
There you go, 26x26 grid.
Alright well hey, I want to thank Kris for sending that question in, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
