-
-
Save candoom/4a53477c8db5eb42891b05a5366f104b to your computer and use it in GitHub Desktop.
Copy this formula into an Excel cell to generate a random 9-character password
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Copy this formula into an Excel cell to generate a random 9-character password. Then | |
Copy & Paste Special (as value) in place in order to avoid the cell being continuosly | |
re-evaluated. Formula taken from: | |
http://ficility.net/2013/04/26/easy-excel-based-password-generator/. | |
=CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(97;122))&CHAR(RANDBETWEEN(97;122))&CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(1000;9999)&CHAR(RANDBETWEEN(42;43)) | |
>>> If it does not work, try like this (commas instead of semicolons): | |
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9999)&CHAR(RANDBETWEEN(42,43)) | |
>>> German version (danke @Cyberkommander!) | |
=ZEICHEN(ZUFALLSBEREICH(65;90))&ZEICHEN(ZUFALLSBEREICH(97;122))&ZEICHEN(ZUFALLSBEREICH(97;122))&ZEICHEN(ZUFALLSBEREICH(65;90))&ZUFALLSBEREICH(1000;9999)&ZEICHEN(ZUFALLSBEREICH(42;43)) | |
>>> Portoguese version (muito obrigado @THISisREALISTIC!) | |
=CARÁT(ALEATÓRIOENTRE(65;90))&CARÁT(ALEATÓRIOENTRE(97;122))&CARÁT(ALEATÓRIOENTRE(97;122))&CARÁT(ALEATÓRIOENTRE(65;90))&ALEATÓRIOENTRE(1000;9999)&CARÁT(ALEATÓRIOENTRE(42;43)) | |
>>> French version (merci beaucoup @foutrak!) | |
=CAR(ALEA.ENTRE.BORNES(65;90))&CAR(ALEA.ENTRE.BORNES(97;122))&CAR(ALEA.ENTRE.BORNES(97;122))&CAR(ALEA.ENTRE.BORNES(65;90))&ALEA.ENTRE.BORNES(1000;9999)&CAR(ALEA.ENTRE.BORNES(42;43)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment