excel password formula

zap

I have 400 users to give initial passwords to and I don't fancy making up 400 passwords so all the usernames are in an excel spreadsheet can anyone give me a formula that would create a random password.

Also secuirty isn't a worry they will be forced to change on first login, passwords must be over 6 characters and have at least 1 letter and 1 number.

SwampThing

Why not something like first letter of first name, all of surname, remove any apostophies etc. and then replace all the vowels with an extended character and then lower-case it all.


Example: Mary O'Hara would be m0h9r9 - Elaine Burns would be 3b4rns

just make a map for the vowels - a = 9, e = 3, i = 1, o = 0 and u = 4

Capt'n Midnight

you can do it in DOS

set /P user=Enter user name
Set %pw%=Pa%random%
NET USER %user% %pw% /ADD /Domain
echo %user% %pw% >> password.lst

and combine with something like
for /F %%i in (user.lst) do call set PW %%i

zap

SwampThing wrote:

Why not something like first letter of first name, all of surname, remove any apostophies etc. and then replace all the vowels with an extended character and then lower-case it all.


Example: Mary O'Hara would be m0h9r9 - Elaine Burns would be 3b4rns

just make a map for the vowels - a = 9, e = 3, i = 1, o = 0 and u = 4

how would i do that in excel and rmeove the spaces etc.

BTW won't be doing it in DOS cause I use macs.

SwampThing

PM me your e-mail address - I'll send you a sample spreadsheet.

Capt'n Midnight

zap wrote:

BTW won't be doing it in DOS cause I use macs.

LOL - am I don't use Excel

(OpenOffice uses a ; where excel uses , )


simple subsitution doesn't increase entrophy much, random numbers might be better

A1 = forename
B1 = Surname
C1 = UPPER(LEFT(A1))&LOWER((B1))&RANDBETWEEN(100;999)

Fred Bloggs Fbloggs747

(if you haven't split the names open the user list in a text editor - not word and replace spaces with commas and then tell excel it's a text only file when opening it)