(3.) You can use the character & to add the number of letters you need.ģ. 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 can generate a random letter from a to z, if you need to create four random letters, you need to use & character to add the letters. To create a random letter, use the this formula: =CHAR(RANDBETWEEN(65,90)). Note: you can change the arguments to get your need.Ģ. To create a 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: The following formulas can help you generate random numbers, letters and alphanumeric values in a range in Excel.ġ. Generate random character strings with VBA codeĮasily generate random character strings with Kutools for Excel Generate random character strings with formulas This article tries to show you some tricks to generate different random strings in Excel. Sometimes you may need to generate random strings in cells, such as different passwords.
#Excel data generator how to
How to generate random character strings in a range in Excel?
0 kommentar(er)
