You may find yourself faced with a need to generate a ton of random strings of characters.
For example, you may have a list of usernames that need passwords – you could be lazy and say everyone’s password is password, but I will assume you know better than that!
Generate Random Number String
To generate a random number string in Excel, simply use a formula like this:
=RANDBETWEEN(0,9)
This will randomly display a number between 0 and 9 each time the page is refreshed. Read More