Using Excel to create a password

Closed
themaizeandblue Posts 2 Registration date Tuesday 28 February 2012 Status Member Last seen 29 February 2012 - 28 Feb 2012 à 01:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Mar 2012 à 16:17
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Feb 2012 à 09:33
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
themaizeandblue Posts 2 Registration date Tuesday 28 February 2012 Status Member Last seen 29 February 2012
29 Feb 2012 à 02:43
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.
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
5 Mar 2012 à 09:08
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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Mar 2012 à 16:17
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 ?