Using random number generator to generate numbers and password in Excel

Normally if you want to generate random number in Excel, you have to learn how to use the Excel’s RAND or RANDBETWEEN function to generate random number for you. Generally speaking, it’s not easy for you to quickly generate random number in Excel. But with this powerful Insert Random Data utility of Kutools for Excel, you can quickly:

Generate / insert random numbers in a range

Generate / insert random date in a range

Generate / insert password (random data strings) or specified formatting data strings in a range

Generate / insert a custom list in a rangeDemo

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

arrow blue right bubble Click Kutools >> Insert Tools >> Insert Random Data. See screenshots:

shot-generate-random-data1shot-generate-random-data2

arrow blue right bubble Generate / insert random numbers in a range

Supposing you want to generate random numbers between 100 and 500, with this tool you can quickly generate / insert random numbers in the selected range.

1. Select the range that you want to generate / insert random numbers.

2. Apply this utility by clicking Kutools > Insert Tools > Insert Random Data, and then click Integer in the Insert Random Data dialog box.

3. Specify the Form value and To value that you need into the box. See screenshot:

shot-generate-random-data3

4. Click OK or Apply, (if you click OK, the dialog box will be closed, and if you click Apply, the dialog box will not be closed, and you can still apply other options). You will see the results as follows. see screenshot:

shot-generate-random-data4


arrow blue right bubble Generate / insert random date in a range

Sometimes, you need to generate / insert random date into a range, such as the date of workdays or weekends of a period of date, you can do as follows.

1. Specify the range that you want to insert random date.

2. Go to the Insert Random Data dialog box, click Date, and modify the date to meet your need. Specify the type of date or not. See screenshot:

shot-generate-random-data5

A: Specify the date range.

B: If you check Workday, all of the dates of workdays in certain time will be generated randomly, so does Weekend.

3. Click OK or Apply. You will see the results as follows. See screenshot:

shot-generate-random-data6


arrow blue right bubble Generate / insert password (random data strings) or specified formatting data strings in a range

Supposing you want to generate or insert random date strings in a range, and use the random data strings as password, yo can do as follows:

1. Select the range you want to generate / insert data strings (password).

2. Go to the Insert Random Data dialog box, click String.

3. Specify the characters and the length of string, see screenshot:

shot-generate-random-data7

4. Then click OK or Apply. See screenshot:

shot-generate-random-data8

Further more, you can also generate or insert a specified formatting data strings (such as ????@.??.com) in a range as follows:

1. Select a range and specify the characters and check By mask. Then input the specified data strings you need. See screenshot:

shot-generate-random-data9

Note: Using ? to indicate a digit of random character in the final specified formatting strings.

2. Then click OK or Apply. The specified formatting data strings have been generated randomly as follows. See screenshot:

shot-generate-random-data10


arrow blue right bubble Generate / insert a custom list in a range

With this utility, you can also quickly generate or insert a custom list in cells.

1. Select a range you need to insert the custom list.

2. Apply this utility, and in the Insert Random Data dialog box, click Custom list. You can select the data in the list you like or click Add to create a list. See screenshot:

A: You can quickly extract data from cells to create a new custom list.

3. Click OK and the new list has been added into the list, also you can edit and remove the custom list.

4. Then click OK or Apply. The new data have been inserted into the specified range. see screenshot:

shot-generate-random-data12


arrow blue right bubbleNotes:

1. This utility supports Undo operation, so you can press Undo (Ctrl+Z) immediately to restore it.

2. Unique values option will only generate or insert unique values in the range.


arrow blue right bubbleSee Insert Random Data feature demo (video 1)

Video 1. Insert Random Data feature demo.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 120 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase