🌐
Statology
statology.org › home › how to generate a random password in excel (with example)
How to Generate a Random Password in Excel (With Example)
September 18, 2023 - We will type the following formula into cell A2 in Excel to generate a random 8-character password that contains uppercase letters, lowercase letters, and numbers:
🌐
ExtendOffice
extendoffice.com › documents › excel › how to quickly generate random password in excel?
How to quickly generate random password in Excel?
With "Insert Random Data" utility, you also can insert random whole numbers, random dates and time, random custom list. In summary, whether you choose to manually craft your passwords using Excel functions or opt for the enhanced capabilities of Kutools for Excel, both methods provide reliable and secure ways to generate random passwords that can protect your sensitive information from unauthorized access.
🌐
Microsoft Community
techcommunity.microsoft.com › microsoft community hub › communities › products › microsoft 365 › excel
password generator - Excel
how to create password generator
🌐
GitHub
gist.github.com › coccoinomane › 501e9520168033eee518
Copy this formula into an Excel cell to generate a random 9-character password · GitHub
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))
🌐
PCMAG
pcmag.com › home › how-to › security › password managers
DIY Security: How to Create Your Own Strong Password Generator | PCMag
September 1, 2024 - When I first created this spreadsheet, I used a simple-minded technique to create a random password. I started with a formula that returns one random character drawn from that string living in cell D8: ... This tells Excel to generate a random number from one to the length of the string and return one character at that location.
🌐
SpreadsheetWeb
spreadsheetweb.com › home › how to create a random secure password in excel
How to create a random secure password in Excel
March 27, 2019 - Copy down the formula for the rest ... =CONCATENATE(G3,G4,G5,G6,G7,G8,G9,G10) You can generate random characters by combining the CHAR and RANDBETWEEN functions....
🌐
Ablebits
ablebits.com › docs › excel-generate-random-values
Generate random numbers, names, passwords, strings, codes, etc. in Excel
The Random Generator add-in lets you quickly populate the selected cells with random records of any chosen type. With this tool, you can create random numbers without duplicate records, randomize values from your custom list, or obtain secure ...
🌐
The Bricks
thebricks.com › resources › guide-how-to-create-random-password-in-excel-with-special-characters
How to Create a Random Password in Excel with Special Characters
Learn how to create strong, random passwords with special characters directly in Excel. Discover formulas and methods to generate secure, unpredictable passwords easily.
🌐
Reddit
reddit.com › r/excel › random password generator
r/excel on Reddit: Random Password Generator
June 7, 2018 -

This file creates a random, one-time, 8- to 24-character password. It uses the RANDBETWEEN, VLOOKUP, and LEFT functions. Press F9 to create a new password and copy the cell.

https://1drv.ms/x/s!AopBLKdB0SpNgcE485NBu7D3S5mdtg

I hope you find it useful. Feedback is appreciated.

{It's for those of us who don't like cloud-based passwords.)

Top answer
1 of 2
2
Nice. you can also simply D through H by the use of: =CHAR(RANDBETWEEN(33,126)) you can also use rept function to focus on character length. So if you place the desired password length in A2 say, A2=12, this formula you can place in B2: =REPT(CHAR(RANDBETWEEN(33,126)),A2>=1)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=2)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=3)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=4)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=5)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=6)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=7)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=8)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=9)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=10)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=11)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=12)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=13)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=14)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=15)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=16)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=17)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=18)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=19)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=20)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=21)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=22)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=23)&REPT(CHAR(RANDBETWEEN(33,126)),A2>=24) and it will give you the desired password length.
2 of 2
2
Or you could just use KeePass . When you're talking about cloud-based passwords, I assume you're referring to Lastpass or similar services? What don't you like about them?
🌐
Excel tutorials
excelhead.com › 2024 › 11 › 05 › excel-random-password-generator
EXCEL Random password generator – Excel tutorials
September 25, 2025 - For a 4-character password, insert the below formula in cell A2: =CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(0;9)&CHAR(RANDBETWEEN(97;122))&CHAR(RANDBETWEEN(97;122)) Drag the formula down as long as you want. ... Welcome to Excel tutorials made easy.
Find elsewhere
🌐
YouTube
youtube.com › finally learn
Create a RANDOM Password Generator in Excel - YouTube
14:39
This video shows how to generate random passwords in Excel. The passwords are 15 digits with upper case, lower case, numbers, and special characters. The spr...
Published   May 25, 2021
Views   1K
🌐
YouTube
youtube.com › watch
How To Generate A Random Password In Excel - YouTube
05:06
DOWNLOAD the example workbook here:👉 https://howtoexcel.com/downloadsThanks for all your support!
Published   August 8, 2019
🌐
MrExcel
mrexcel.com › forums › question forums › excel questions
My Random Password Generator | MrExcel Message Board
March 11, 2005 - Once you've generated your table of random characters that fit your password rules, randomly select characters from this table using: =INDEX(G3:J33,RANDBETWEEN(1,30),2) Now, all you have to do to make an N-character random password is string ...
🌐
YouTube
youtube.com › watch
How To Generate Password In Excel - YouTube
How To Generate Password In Excel00:00 - Hello00:11 - A simple password00:45 - A complicated password01:10 - ASCII codes=RANDBETWEEN (10000; 99999)=CHAR(RAND...
Published   July 2, 2024
🌐
YouTube
youtube.com › jopa excel
How to Password Generator in Excel with Random Numbers, Letters and Symbols | RandBetween, Char - YouTube
06:19
How to Password Generator in Excel with Random Numbers, Letters and Symbols | RandBetween, CharIn this Excel video tutorial we will learn how to generate ran...
Published   September 7, 2023
Views   4K
🌐
ExcelHow
excelhow.net › home
Generate Random Passwords - Free Excel Tutorial
February 19, 2023 - This tutorial video provides step-by-step instructions on how to use Excel’s built-in functions to generate random passwords or letters in Excel, making it easy to create secure and unique passwords for a variety of purposes.
🌐
The Windows Club
thewindowsclub.com › the windows club › office › how to generate a random strong password in excel
How to generate a Random Strong Password in Excel
April 13, 2025 - Shift+F9 hotkey is used to refresh a cell value in Microsoft Excel. Hence, to regenerate a random password, you can press this hotkey and see the changed random password. Coming to declaring values for the above-mentioned fields, start from ...
🌐
Stack Overflow
stackoverflow.com › questions › 74694845 › how-to-generate-a-random-alphanumeric-string-with-a-formula-in-excel-or-google
How to generate a random alphanumeric string with a formula in Excel (or Google Sheets or LibreOffice) - Stack Overflow
Top answer
1 of 6
6

in GS try:

=LAMBDA(x, x)(DEC2HEX(RANDBETWEEN(0, HEX2DEC("FFFFFFFF")), 8))

if that's not enough and you need

  • A-Z char 65-90
  • a-z char 97-122
  • 0-9 char 48-58
=JOIN(, BYROW(SEQUENCE(8), LAMBDA(x, IF(COINFLIP(), IF(COINFLIP(), 
 CHAR(RANDBETWEEN(65, 90)), CHAR(RANDBETWEEN(97, 122))), RANDBETWEEN(0, 9)))))

frozen:

=LAMBDA(x, x)(JOIN(, BYROW(SEQUENCE(8), LAMBDA(x, IF(COINFLIP(), IF(COINFLIP(), 
 CHAR(RANDBETWEEN(65, 90)), CHAR(RANDBETWEEN(97, 122))), RANDBETWEEN(0, 9))))))

alternative (with better distribution):

=JOIN(, BYROW(SEQUENCE(8), LAMBDA(x, SINGLE(SORT(CHAR({
 SEQUENCE(10, 1, 48); 
 SEQUENCE(26, 1, 65); 
 SEQUENCE(26, 1, 97)}), 
 RANDARRAY(62, 1), )))))

or frozen:

=LAMBDA(x, x)(JOIN(, BYROW(SEQUENCE(8), LAMBDA(x, SINGLE(SORT(CHAR({
 SEQUENCE(10, 1, 48); 
 SEQUENCE(26, 1, 65); 
 SEQUENCE(26, 1, 97)}), 
 RANDARRAY(62, 1), ))))))

for more see: stackoverflow.com/questions/66201364

2 of 6
6

LibreOffice Calc 7.x:

A non-volatile option for LibreOffice Calc 7.x is the use of the RANDBETWEEN.NV() function:

Formula in A1:

=CONCAT(IF({1,2,3,4,5,6,7,8},MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789",RANDBETWEEN.NV(1,62),1),))

Note that using ROW(1:8) would still force recalculation when any value in rows 1-8 have been made (thus volatile):

=CONCAT(IF(ROW(1:8),MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789",RANDBETWEEN.NV(1,62),1),))

Excel ms365:

Unfortunately there is, AFAIK, not a non-volatile Excel equivalent to this function. If volatility is not a problem, then try:

=CONCAT(MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789",RANDARRAY(8,,1,62,1),1))
🌐
Buffcom
buffcom.net › creating-a-strong-random-password-in-excel
Creating a Strong Random Password in Excel
March 21, 2023 - Creating a Strong Random Password in Excel and Syntax to create random characters: = RANDBETWEEN (0,9) (Number) = CHAR (RANDBETWEEN (65,90)) (Uppercase letter) = CHAR (RANDBETWEEN (97,122)) (Lowercase letter) = CHAR (RANDBETWEEN (33,47)) (Symbol) ...
🌐
Excel Forum
excelforum.com › excel-formulas-and-functions › 1393144-password-generator-excel.html
Password Generator Excel
Good morning I am looking to create an excel spreadsheet to create random passwords for when users call up to make life easier and to not use an online password generator. What I am looking for is to create an index with a dictionary of words to populate two cells with two words and add a number ...