# Trying to generate passwords from a list of user names

#### Flying_Kiwi

##### New Member
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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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

Thank you. Yes you are correct, by itself it would make a password which would be no more secure than a wet paper bag

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"

Replies
1
Views
11K

1,221,008
Messages
6,157,357
Members
451,416
Latest member
Ilu

### 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?

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