Create Random Number Generator

Is it possible to randomly generate an 8 alphanumeric string rather than just numeric string. Numbers and alpha order should also be random, purpose: trying to simulate password entries for test data

Use this formula http://www.tushar-mehta.com/excel/ti..._alphanum.html
...8 times (8 rows) and then concatenate all the rows to one Alphanumeric string.
=A1&A2&A3&A4&A5&A6&A7&A8

HTH
Ola Sandström

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Here is another way.

Put this in A1 (or give it a Name):
0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz

Then copy this to A2:
=MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)&MID($A$1,1+INT(RAND()*LEN($A$1)),1)

Ola Sandström

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>

Type 0 thru 9 and A thru Z in cells A1 thru A43

Next on any cell type
=INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))&INDEX($A$1:$A$43,RANDBETWEEN(1,43))

This is your 8 digit random password

For Randbetween you will need Analysis tool pak addin

"Pascale" <Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com> wrote in
message news:Pascale.1rtqn2_1120781156.1385@excelforum-nospam.com...
>
> Is it possible to randomly generate an 8 alphanumeric string rather than
> just numeric string. Numbers and alpha order should also be random,
> purpose: trying to simulate password entries for test data
>
>
> --
> Pascale
> ------------------------------------------------------------------------
> Pascale's Profile:
> http://www.excelforum.com/member.php...o&userid=12546
> View this thread: http://www.excelforum.com/showthread...hreadid=385434
>