Copy this formula into an Excel cell to generate a random 9-character password

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.

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

Russian version (Спасибо @1shindes!)

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

Dutch version (Bedankt @KarenBBla!)

=TEKEN(ASELECTTUSSEN(65;90))&TEKEN(ASELECTTUSSEN(97;122))&TEKEN(ASELECTTUSSEN(97;122))&TEKEN(ASELECTTUSSEN(65;90))&ASELECTTUSSEN(1000;9999)&TEKEN(ASELECTTUSSEN(42;43))

Hungarian (magyar) version (Köszönöm @Nortonor!)

=TEKEN(ASELECTTUSSEN(65;90))&TEKEN(ASELECTTUSSEN(97;122))&TEKEN(ASELECTTUSSEN(97;122))&TEKEN(ASELECTTUSSEN(65;90))&ASELECTTUSSEN(1000;9999)&TEKEN(ASELECTTUSSEN(42;43))

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

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

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

Thanks guys, I have update the gist!

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

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

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

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

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

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

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

You're a damn hero!

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

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

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

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

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

It makes me happy ❤️

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

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 😂

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

Dutch version:
=TEKEN(ASELECTTUSSEN(65;90))&TEKEN(ASELECTTUSSEN(97;122))&TEKEN(ASELECTTUSSEN(97;122))&TEKEN(ASELECTTUSSEN(65;90))&ASELECTTUSSEN(1000;9999)&TEKEN(ASELECTTUSSEN(42;43))

Thank you @1shindes and @KarenBBla, I added your versions to the gist ❤️

Hungarian (magyar) version:
=KARAKTER(VÉLETLEN.KÖZÖTT(65;90))&KARAKTER(VÉLETLEN.KÖZÖTT(97;122))&KARAKTER(VÉLETLEN.KÖZÖTT(97;122))&KARAKTER(VÉLETLEN.KÖZÖTT(65;90))&VÉLETLEN.KÖZÖTT(1000;9999)&KARAKTER(VÉLETLEN.KÖZÖTT(42;43))

Köszönöm @Nortonor, added the magyar version to the gist 💪