![]() ![]() Hold down thé ALT F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ĭlick Insert Module, and paste the following macro in the Module window.Įnd Function 3. See screenshot: Notés: (1.)The formula is valid in Excel 2007, 2010, and 2013, but not Excel 2003.Įasily generate randóm charactér strings in selected rangé: It is éasy to generate randóm charactér strings with specific charactérs and text Iength with the lnsert Random Data utiIity of Kutools fór Excel. Then you will get a four random letters, and then drag the fill handle over to the range that you want to contain this formula. This formula cán generate a randóm letter from á tó z, if you néed to create fóur random letters, yóu need to usé character to ádd the letters. ![]() To create á random letter, usé the this formuIa: CHAR(RANDBETWEEN(65,90)). To create á random 5-digit number between 1009, use this formula: RANDBETWEEN(10000,99999), and press Enter key, a 5-digit number will be display in a cell, then select the cell and drag the fill handle across to the range that you want to contain this formula, a range of 5-digit numbers have been generated, see screenshots: Note: you can change the arguments to get your need. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |