Password generator using Excel

[mwredt]

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?

 

[Couriant]

Can you provide a link to the tutorial?

 

[zebanovich]

It works fine in Excel 2019, I only had to replace comma with colon for RANDBETWEEN:

=CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(100;999)&LOWER(CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(33;39)))

 

[Couriant]

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]

It works fine in Excel 2019, I only had to replace comma with colon for RANDBETWEEN:

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

 

[zebanovich]

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

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.

 

[Couriant]

I did check a website that has this code and does report it work with 2003.

 

[mwredt]

Can you provide a link to the tutorial?

This is the link for that tutorial.

 

[mwredt]

This is the link for that tutorial.

This is the link for the tutorial.

 

[mwredt]

This is the link for the tutorial.

I did check a website that has this code and does report it work with 2003.

Mine won't work with semicolons either, so I put the commas back in and got the same result--#NAME?

 

[zebanovich]

Excel 2003 does not support RANDBETWEEN function.
This function was introduced in Excel 2007:

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Starter 2010

RANDBETWEEN function - Office Support (microsoft.com)

 

[mwredt]

Excel 2003 does not support RANDBETWEEN function.
This function was introduced in Excel 2007:


RANDBETWEEN function - Office Support (microsoft.com)

What does Excel 2003 use instead of RandBetween?

 

[zebanovich]

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]

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.

 

[zebanovich]

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.