Using Excel to create a password

Closed
themaizeandblue Posts 2 Registration date Tuesday February 28, 2012 Status Member Last seen February 29, 2012 - Feb 28, 2012 at 01:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 04:17 PM
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.



Related:

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 28, 2012 at 09:33 AM
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
0
themaizeandblue Posts 2 Registration date Tuesday February 28, 2012 Status Member Last seen February 29, 2012
Feb 29, 2012 at 02:43 AM
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.
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 5, 2012 at 09:08 AM
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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 04:17 PM
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 ?
0