Generate random number with the given specific length in Excel
Today, we may use multiple passwords in our daily work, and the password may be in different length. If you are tired to set a password, you can use formulas or a handy tool to generate random passwords for you. Here this tutorial provides some tricks to generate random numbers in your desired length in Excel.
Random number in a given specific length with using formula
Random number in a fixed length
Supposing you want to generate a random number string in 6-digit length, you can use this formula
Press Enter key, then then a random number in 6-digit length is outputted.
Note: The output number will be changed when every time the worksheet is updated.
Random number in a changed length based on the digit number you type in another cell
In some times, you may need to generate passwords in different lengths, for instance, when you type 5 in cell A1, the cell A2 will display a random number in 5-dighit length, if you type 9 in cell A1, the A2 displays a 9-digit number.
Press Enter key, now it displays blank as the cell A1 is empty.
From now on, when you type a number in A1 and press Enter key, it generates a random number in the specific length in cell A2 based on the number you typed in cell A1.
Note: The number will be changed when every time the worksheet is update.
Random number or other characters in a given length with using a handy tool
If you not only want random number string in length, but also want random decimal number or integer number in a number range, or random text strings, or random date or time or custom list, you can try a handy tool, the Insert Random Data utility of Kutools for Excel.
Generate random date between two dates quickly in Excel When you use an Excel file, sometimes you want to generate random date for some purpose, of course, you can enter the date manually one by one, but if you need to insert multiple dates, this method will be time-consuming and boring. How to quickly generate random date on earth in Excel?