Generate a Random Character String in Excel

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:


This will randomly display a number between 0 and 9 each time the page is refreshed. Read More