Trying to generate passwords from a list of user names

Flying_Kiwi

New Member
Joined
Jun 1, 2003
Messages
4
I have a column of approx three hundred user names and I am trying to create individual passwords based on the total ASCII value of the following
A2 - First Name B2 - Last Name C2 - User Id;
Nb the user ID usually, but not always, takes the form LLLLL-N L=Letters N=Number.
This does not need to be a highly secure password - it's not for NSA or something like that.
I did play, unsuccesfuly, with the ROT13() function found in Open Office, but can't find an equivalent in Excel. But the basic premise of the Ceasar cypher, with minor variations, would probably be sufficient.
Is there an equivalent to the ROT13() function within Excel, or can someone please point me in the correct direction.

Thank you very much for taking the time to read this, any assistance will be gratefully appreciated.

Flying_Kiwi
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

zzjasonzz

Well-known Member
Joined
Apr 23, 2006
Messages
649
wouldn't that just make the password a bunch of numbers?
um this will add up the ascii value of every letter then put the total in column D

Code:
Sub totalascii()
totalasc = 0
For i = 2 To Range("A2").End(xlDown).Row
    For j = 1 To 3
        txt = Cells(i, j)
        For k = 1 To Len(txt)
            totalasc = totalasc + Asc(Mid(txt, k, 1))
        Next k
    Next j
    Range("D" & i) = totalasc
    txt = 0
Next i
End Sub

but i have a feeling that would make for a pretty poor password
 

Flying_Kiwi

New Member
Joined
Jun 1, 2003
Messages
4
Thank you. Yes you are correct, by itself it would make a password which would be no more secure than a wet paper bag :p

But I am planing on using the sequence of numbers generated as some sort of "seed" for something equivalent to the ROT13() function from Open Office, which will rotate a particular character 13 places, Eg A becomes N, B becomes O etc. I don't think Excel has this function, but I am trying to create something like that, probably as some sort of macro.

Once again, thank you very much for taking the time to help me "A Kiwi" :LOL:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,102
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top