Skip to content

Instantly share code, notes, and snippets.

@coccoinomane

coccoinomane/Excel Password Generator.md

Last active May 1, 2024 00:47
Show Gist options
  • Star 32 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save coccoinomane/501e9520168033eee518 to your computer and use it in GitHub Desktop.
Save coccoinomane/501e9520168033eee518 to your computer and use it in GitHub Desktop.
Download ZIP
Copy this formula into an Excel cell to generate a random 9-character password
Raw
Excel Password Generator.md

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/.

English version

=CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(97;122))&CHAR(RANDBETWEEN(97;122))&CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(1000;9999)&CHAR(RANDBETWEEN(42;43))

English version (with commas)

If the previous formula does not work, try with 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))

Spanish version (gracias @soportesistemas4)

=CARACTER(ALEATORIO.ENTRE(65,90))&CARACTER(ALEATORIO.ENTRE(97,122))&CARACTER(ALEATORIO.ENTRE(97,122))&CARACTER(ALEATORIO.ENTRE(65,90))&ALEATORIO.ENTRE(1000,9999)&CARACTER(ALEATORIO.ENTRE(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))

Brazilian portoguese version (muito obrigado @eulergui!)

=CARACT(ALEATÓRIOENTRE(65;90))&CARACT(ALEATÓRIOENTRE(97;122))&CARACT(ALEATÓRIOENTRE(97;122))&CARACT(ALEATÓRIOENTRE(65;90))&ALEATÓRIOENTRE(1000;9999)&CARACT(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))

Italian version (dajeeee @iomariani!)

=CARATT.UNI(CASUALE.TRA(65;90))&CARATT.UNI(CASUALE.TRA(97;122))&CARATT.UNI(CASUALE.TRA(97;122))&CARATT.UNI(CASUALE.TRA(65;90))&CASUALE.TRA(1000;9999)&CARATT.UNI(CASUALE.TRA(42;43))

Polish version (na zdrowie @weedget!)

=ZNAK(LOS.ZAKR(65;90))&ZNAK(LOS.ZAKR(97;122))&ZNAK(LOS.ZAKR(97;122))&ZNAK(LOS.ZAKR(65;90))&LOS.ZAKR(1000;9999)&ZNAK(LOS.ZAKR(42;43))
@afanucchi
Copy link

afanucchi commented Mar 1, 2018 •
edited

Please note, the parameter separator is meant to be a comma , and not a semi-colon ; between each of those number pairs! (Might be Excel 2013+)

@gonik
Copy link

gonik commented Mar 3, 2018

@afanucchi in most EU countries, the semicolon is used for the separator, instead for the comma

@Cyberkommander
Copy link

German Excel:
=ZEICHEN(ZUFALLSBEREICH(65;90))&ZEICHEN(ZUFALLSBEREICH(97;122))&ZEICHEN(ZUFALLSBEREICH(97;122))&ZEICHEN(ZUFALLSBEREICH(65;90))&ZUFALLSBEREICH(1000;9999)&ZEICHEN(ZUFALLSBEREICH(42;43))

@coccoinomane
Copy link
Author

Thanks guys, I have update the gist!

@THISisREALISTIC
Copy link

In Portuguese EU:

=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))

@coccoinomane
Copy link
Author

Thanks @THISisREALISTIC, I added your contribution to the gist 👍

@foutrak
Copy link

foutrak commented Apr 29, 2021

Also in French Excel :
=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))

@coccoinomane
Copy link
Author

Merci @foutrak for the French formula! It is now in the gist :-)

@weedget
Copy link

weedget commented Aug 9, 2021

if you want to add Polish version here it is:
=ZNAK(LOS.ZAKR(65;90))&ZNAK(LOS.ZAKR(97;122))&ZNAK(LOS.ZAKR(97;122))&ZNAK(LOS.ZAKR(65;90))&LOS.ZAKR(1000;9999)&ZNAK(LOS.ZAKR(42;43))

@coccoinomane
Copy link
Author

Thanks @weedget, I included the Polish formula in the gist 👍
We are getting better than the UN!!! 😂

@soportesistemas4
Copy link

soportesistemas4 commented Feb 26, 2022 •
edited

Spanish
CARACTER(ALEATORIO.ENTRE(65,90))&CARACTER(ALEATORIO.ENTRE(65,90))&ALEATORIO.ENTRE(100,999)&CARACTER(ALEATORIO.ENTRE(65,90))

@robertPlace
Copy link

You're a damn hero!

@eulergui
Copy link

In Brazilian Portuguese:
=CARACT(ALEATÓRIOENTRE(65;90))&CARACT(ALEATÓRIOENTRE(97;122))&CARACT(ALEATÓRIOENTRE(97;122))&CARACT(ALEATÓRIOENTRE(65;90))&ALEATÓRIOENTRE(1000;9999)&CARACT(ALEATÓRIOENTRE(42;43))

@coccoinomane
Copy link
Author

coccoinomane commented Nov 15, 2022 •
edited

Thank you @soportesistemas4 and @eulergui: I added your formulas to the gist 💪🌎🕊

@iomariani
Copy link

Italian 🇮🇹
=CARATT.UNI(CASUALE.TRA(65;90))&CARATT.UNI(CASUALE.TRA(97;122))&CARATT.UNI(CASUALE.TRA(97;122))&CARATT.UNI(CASUALE.TRA(65;90))&CASUALE.TRA(1000;9999)&CARATT.UNI(CASUALE.TRA(42;43))

@robertPlace
Copy link

Just want to comment again that I still use this daily for about a year now.

@coccoinomane
Copy link
Author

Just want to comment again that I still use this daily for about a year now.

It makes me happy ❤️

@foutrak
Copy link

foutrak commented Dec 9, 2022

Still using it and following the thread a year and half after 👍 thanks again

@coccoinomane
Copy link
Author

Still using it and following the thread a year and half after 👍 thanks again

Amazing! Now let’s all hope they don’t crack our passwords 😂

@1shindes
Copy link

1shindes commented May 1, 2024

Here's Russian version:
=СИМВОЛ(СЛУЧМЕЖДУ(65;90))&СИМВОЛ(СЛУЧМЕЖДУ(97;122))&СИМВОЛ(СЛУЧМЕЖДУ(97;122))&СИМВОЛ(СЛУЧМЕЖДУ(65;90))&СЛУЧМЕЖДУ(1000;9999)&СИМВОЛ(СЛУЧМЕЖДУ(42;43))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment