Random Passwords and usernames

[rbsmit02]

I have 500 agents trained on a new tool.
I need to create usernames and passwords for them as I am the admin of this tool.

What I need is thus:
column 1 contains first name space last name.
I want column 2 to format the name to a string in the format first initial last name (ray smith = rsmith).

In the third column I need to generate a random password between 6 and 8 charicters with at least 2 letters in the password.

Any pointers on how to do this?
this project needs to take very little of my time so I do not care what type of solution it is.... VBA or formula

 

[tcg2k5]

I am trying to do something similar without any external addins though and I am only looking to create a random password generator thats alphanumeric.

Here's a "rough draft" shot at the random password:

o237 houses the numbers 0-9 and the letters A-Z.

C2: =RANDBETWEEN(6,8)
D2: =IF($C2>=D$1,OFFSET($O$1,RANDBETWEEN(1,36),0),"")
L2: =D2&E2&F2&G2&H2&I2&J2&K2
M2: =IF(SUM(ISNUMBER(VALUE(LEFT(L2,1)))+ISNUMBER(VALUE(MID(L2,2,1)))+ISNUMBER(VALUE(MID(L2,3,1)))+ISNUMBER(VALUE(MID(L2,4,1)))+ISNUMBER(VALUE(MID(L2,5,1)))+ISNUMBER(VALUE(MID(L2,6,1)))+ISNUMBER(VALUE(MID(L2,7,1)))+ISNUMBER(VALUE(MID(L2,8,1))))<C2-2,"yes","no")

Book13
	C	D	E	F	G	H	I	J	K	L	M	N	O
1	length	1	2	3	4	5	6	7	8	full	valid?
2	6	X	C	X	S	F	Z			XCXSFZ	yes		0
3													1
4													2
5													3
6													4
7													5
8													6
9													7
10													8
11													9
12													A
13													B
14													C
15													D
16													E
Sheet1

 

[NateO]

Hello,

I am trying to do something similar without any external addins though and I am only looking to create a random password generator thats alphanumeric.

Very good. What's the question then?

There are native solutions that do not require Add-ins posted to this thread, including the solutions mentioned by Tushar and I.

Incidentally, the UDF I posted is a good example of how native VB[A] algorithms can be extremely efficient...

The spreadsheet you quoted does use the Analysis Toolpak, a 3rd party Add-in (for Randbetween() ).