Using Excel to create a password

[Closed]
Report
Posts
2
Registration date
Tuesday February 28, 2012
Status
Member
Last seen
February 29, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am looking for a way to use Excel to create a password of the same length and type from a serial number. Example: Serial # 45ABZW2BLS to a password of E0DA2DD927

Not sure if it would make a difference or not, but the 45ABZ part of the serial # never changes.

Thanks in advance for any help and or answers.



2 replies

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi themaizeandblue,

So you want to convert serial numbers to passwords.
What is the relation between the two?

How do you go from 45ABZW2BLS to E0DA2DD927?

Best regards,
Trowa
Posts
2
Registration date
Tuesday February 28, 2012
Status
Member
Last seen
February 29, 2012

I don't know how it would go from one to the other. That's what I'm asking.

The only relation is that the serial number has 10 numbers and letters and the password that is generated also has 10. The serial number always starts with the same 5, but generates a 10 numbers and letters.

The example I gave is what an excel program generated as a password from that serial number.

I would think that there is some type of formula that is used to make that password be the same everytime that exact serial number is put into the program.

Thanks for your interest.
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Sorry themaizeandblue, I'm not familiar with a formula that generates a random combination of letters and numbers based on a value.

And if it would be random, then the password will differ every time.

Best regards,
Trowa
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Looking at your example, it is not really a creation of password. It is rather transformation of values like in classic manner
A =F. B=T , J =B etc
Is that's what you intent is ?