Password generator using Excel

mwredt

Thread Starter
Joined
Mar 21, 2005
Messages
640
Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 10 Home, 64 bit, Build 19041, Installed 20200727142315.000000-300
Processor: AMD Athlon(tm) II X4 630 Processor, AMD64 Family 16 Model 5 Stepping 2, CPU Count: 4
Total Physical RAM: 4 GB
Graphics Card: AMD Radeon HD 5700 Series, 1024 MB
Hard Drives: C: 464 GB (386 GB Free);
Motherboard: Gigabyte Technology Co., Ltd. GA-MA74GM-S2, ver x.x
System: Award Software International, Inc., ver GBT - 42302e31
Antivirus: Windows Defender, Enabled and Updated

I was using a tutorial to create a password generator using Excel. I followed directions carefully and checked several times to make sure everything was correct. At the end I was told to press enter and it would generate a password. But when I hit enter the only thing that came up was #NAME?
Here is the string I was told to create:
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(100,999)&LOWER(CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(33,39)))
Not long ago I tried with a different program and the same thing happened. My copy of Microsoft Excel is dated 2003. I don't know if that has anything to do with the problem.
Can anyone tell from this what my problem is?
 
Joined
Mar 2, 2019
Messages
1,626
It works fine in Excel 2019, I only had to replace comma with colon for RANDBETWEEN:
Java:
=CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(100;999)&LOWER(CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(33;39)))
 

Couriant

James
Moderator
Joined
Mar 26, 2002
Messages
38,856
I did try the code you posted and was able to get a 7 digit code. When I tried it on another cell, it changed my original cell, so that is something to think about.

I don't think it's a 2003 issue...
 

Couriant

James
Moderator
Joined
Mar 26, 2002
Messages
38,856
It works fine in Excel 2019, I only had to replace comma with colon for RANDBETWEEN:
Java:
=CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(100;999)&LOWER(CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(33;39)))
hmm yours doesn't work with my Excel365... it doesn't like the semi colons.
 
Joined
Mar 2, 2019
Messages
1,626
it doesn't like the semi colons.
It's because of a regional setting for countries using metric system (if I'm not wrong), but I forgot which option controls this :unsure:

EDIT:
Ah I think it's in control panel -> region -> additional settings -> list separator.
Looks like it has nothing to do with U.S vs metric system, but each locale has either comma or semi colon separator.
 
Last edited:

Couriant

James
Moderator
Joined
Mar 26, 2002
Messages
38,856
I did check a website that has this code and does report it work with 2003.
 
Joined
Mar 2, 2019
Messages
1,626
Open your Excel and Click on "Formulas" tab and click on "Insert function"
Into "search for function" box type RAND and click GO

Does that offer any functions?
 

mwredt

Thread Starter
Joined
Mar 21, 2005
Messages
640
Open your Excel and Click on "Formulas" tab and click on "Insert function"
Into "search for function" box type RAND and click GO

Does that offer any functions?
Only Only one in the box and that is RAND, then below the box in bold letters is RAND(), but this does not allow me to generate a number or letter or symbol BETWEEN for example 65,90 to generate a capital letter from the list of capital letters, lowercase letters, symbols and numbers as the formula wants.
 
Joined
Mar 2, 2019
Messages
1,626
RANDBETWEEN(65;90)

Can also be written as:

ROUND(MAX(90 * RAND(); 65); 0)

Not truly random but can you get it better?
The rest of your job is to implement letters.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top