Generate random password in Excel
Solved
bfiguig
-
tarraf82 -
tarraf82 -
Hello everyone,
is there a way to generate random passwords in Excel?
Thank you in advance.
Best regardsConfiguration: Windows XP
Internet Explorer 6.0
is there a way to generate random passwords in Excel?
Thank you in advance.
Best regardsConfiguration: Windows XP
Internet Explorer 6.0
1 réponse
Hello,
From the moment we can generate random numbers, there is no reason we can't do the same for letters. The challenge is finding a way to obtain words with vowels... which might not be easy!
Try the following method to get 8-letter words:
In column 1, in 8 rows, put the formula: =RANDBETWEEN(1,26)
which will generate a random number between 1 and 26 (we add +1 to avoid 0)
In column 2, also in 8 rows, we will put the corresponding letters:
=CHAR((A1)+64)
(we add +64 because the letter A is the 65th character)
In cell C3, you can concatenate the letters from the 8 rows of column 2, like this:
=$C$1&$C$2&$C$3&$C$4&$C$5&$C$6&$C$7&$C$8
Then press F9 on this cell to update as many times as you want for passwords...
Well, obviously, I've broken it down... But you can certainly make a single formula which would be:
=CHAR((RANDBETWEEN(1,26)+64))
You can do exactly the same thing with a macro.
But... there are surely other more elaborate solutions... that some Excel pros will soon give you!! ;))
m@rina
From the moment we can generate random numbers, there is no reason we can't do the same for letters. The challenge is finding a way to obtain words with vowels... which might not be easy!
Try the following method to get 8-letter words:
In column 1, in 8 rows, put the formula: =RANDBETWEEN(1,26)
which will generate a random number between 1 and 26 (we add +1 to avoid 0)
In column 2, also in 8 rows, we will put the corresponding letters:
=CHAR((A1)+64)
(we add +64 because the letter A is the 65th character)
In cell C3, you can concatenate the letters from the 8 rows of column 2, like this:
=$C$1&$C$2&$C$3&$C$4&$C$5&$C$6&$C$7&$C$8
Then press F9 on this cell to update as many times as you want for passwords...
Well, obviously, I've broken it down... But you can certainly make a single formula which would be:
=CHAR((RANDBETWEEN(1,26)+64))
You can do exactly the same thing with a macro.
But... there are surely other more elaborate solutions... that some Excel pros will soon give you!! ;))
m@rina
Mercimarina
Cool
tarraf82
Thank you for the explanation, clear and simple to use.