Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save candoom/4a53477c8db5eb42891b05a5366f104b to your computer and use it in GitHub Desktop.
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
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