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

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

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.


arrow blue right bubble This is just one of 120 powerful features of Kutools for Excel

It includes more than 120 advaned functions and tools for Excel 2007, 2010 and 2013 (includes Office 365).



btn read more     btn download     btn purchase

Add comment


Security code
Refresh