Trying to generate passwords from a list of user names

[Flying_Kiwi]

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

 

[zzjasonzz]

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

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]

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"