How To Generate Random Strings In Excel


In Microsoft Excel, sometimes you need to generate tons of random strings of characters. It may be different passwords, unique ID's and alphanumeric combinations. May these tutorial help you ease the burden using Excel's RANDBETWEEN function. There could be several ways to do this:

1. Generate Random Number String

To generate a 1-digit random number, simply use a formula like this:

=RANDBETWEEN(0,9)

This will randomly display a number between 0 and 9 each time the worksheet is refreshed or when you press F9.

To generate a 4-digit random number string, simply use a formula like this:

=RANDBETWEEN(1000,9999)

This will randomly display 4-digit numbers between 1000 to 9999 each time the worksheet is refreshed or when you press F9.


2. Generate Random Character String

To generate random uppercase character, simply use a formula like this:

=CHAR(RANDBETWEEN(65,90))

This will randomly display character between A to Z.

To generate random lowercase  character, simply use a formula like this:

=CHAR(RANDBETWEEN(97,122))

This will randomly display a character between a to z.
 

To generate 4 random uppercase character string, simply use a formula like this:
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))

This will randomly display a 4 uppercase character string.




Note: You need to use ampersand (&) in between each formula.  

To generate 4 random lowercase character string, simply use a formula like this:
=CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))

This will randomly display a 4 lowercase character string.

3. Generate Random Symbol String

To generate random symbol, simply use a formula like this:

=CHAR(RANDBETWEEN(33,47))

This will randomly generate one of the following symbols !”#$%&'()*+,-./

4. Generate Random Alphanumeric String:

To generate 8 random alphanumeric strings with 4 numbers and 4 characters, simply use a formula like this:

=RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))

Note: You can also use the CHAR() function in Excel to generate a lot of other symbols.

5. Generate a Random Password


Good passwords tend to have at least eight characters and are a mix of uppercase letters, lowercase letters, numbers, and symbols. To do this, simply combine the above formulas into one formula by simply adding an ampersand (&) in between each formula, like this:

=RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(33,47))&RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(33,47))

This would create something like 0Zt+4Uh" or 6Pv.3Ri%

You can have any combination of letters, numbers or symbols that you want. just play around with these formulas.

Download: Random String Examples

If this helped you then please give a thumbs up, or leave a comment, or link back to this blog.

Thanks!


 
 
Copyright © 2015 - 2017. Simpleng Tips - All Rights Reserved