How to? Create random letters and numbers in a cell
 

Hi All,

I used a spredsheet to create new users onto our network.
We input their name, job title, server and their password they will use to
login to windows.

Is it possible to make some random charaters appear by clicking on the
password cell? EG.

Name Job Function Password Server
John Smith CSR <CLICK Bristol

these passwords have to be in this Format: 2 Uppercase, 5 lower case, 1number.
i.e

UUlllll1

is this possible?

Regards,
Chris

How to? Create random letters and numbers in a cell
 

=CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65))&C HAR(INT(RAND()*26+97))&CHAR(INT(RAND()*26+97))&CHA R(INT(RAND()*26+97))&CHAR(INT(RAND()*26+97))&CHAR( INT(RAND()*26+97))&CHAR(INT(RAND()*10+48))

Regards,
Bernd

How to? Create random letters and numbers in a cell
 

=CHAR(RANDBETWEEN(CODE("A"),CODE("Z")))&CHAR(RANDB ETWEEN(CODE("A"),CODE("Z")))&CHAR(RANDBETWEEN(CODE ("a"),CODE("z")))&CHAR(RANDBETWEEN(CODE("a"),CODE( "z")))&CHAR(RANDBETWEEN(CODE("a"),CODE("z")))&CHAR (RANDBETWEEN(CODE("a"),CODE("z")))&CHAR(RANDBETWEE N(CODE("a"),CODE("z")))&RANDBETWEEN(1,9)

"Chris" wrote:

Hi All,

I used a spredsheet to create new users onto our network.
We input their name, job title, server and their password they will use to
login to windows.

Is it possible to make some random charaters appear by clicking on the
password cell? EG.

Name Job Function Password Server
John Smith CSR <CLICK Bristol

these passwords have to be in this Format: 2 Uppercase, 5 lower case, 1number.
i.e

UUlllll1

is this possible?

Regards,
Chris

How to? Create random letters and numbers in a cell
 

Thanks,

is there a way to make this into such away that when i click the cell the
random password is inputted stright away? as i dont want to have to copy and
past the formula each time

regards,

chris



"Teethless mama" wrote:

=CHAR(RANDBETWEEN(CODE("A"),CODE("Z")))&CHAR(RANDB ETWEEN(CODE("A"),CODE("Z")))&CHAR(RANDBETWEEN(CODE ("a"),CODE("z")))&CHAR(RANDBETWEEN(CODE("a"),CODE( "z")))&CHAR(RANDBETWEEN(CODE("a"),CODE("z")))&CHAR (RANDBETWEEN(CODE("a"),CODE("z")))&CHAR(RANDBETWEE N(CODE("a"),CODE("z")))&RANDBETWEEN(1,9)

"Chris" wrote:

Hi All,

I used a spredsheet to create new users onto our network.
We input their name, job title, server and their password they will use to
login to windows.

Is it possible to make some random charaters appear by clicking on the
password cell? EG.

Name Job Function Password Server
John Smith CSR <CLICK Bristol

these passwords have to be in this Format: 2 Uppercase, 5 lower case, 1number.
i.e

UUlllll1

is this possible?

Regards,
Chris