How can I generate random characters in Excel

[Tayo]

How can I generate random characters (both letters and numbers) into
different cells (both rows & columns) at he same time in excel?

[Andrew Taylor]

Put all the possible characters in a cell, and name it as "list".
Then
=MID(list,1+INT(RAND()*LEN(list)),1)
will give a random character from the list. Use as many of these
as you need.

Andrew

Tayo wrote:
> How can I generate random characters (both letters and numbers) into
> different cells (both rows & columns) at he same time in excel?

[Daniel CHEN]

Try the following formula:

=CHAR(RANDBETWEEN(32,126))

which generates a random char whose ascii code is between 32 and 126.
Please note that 32 corresponding to space.


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download

=================================
"Tayo" <[email protected]> wrote in message
news:[email protected]...
> How can I generate random characters (both letters and numbers) into
> different cells (both rows & columns) at he same time in excel?

[Tayo]

Is the word 'list' in the formular the name of the header for the list? The
formular is not working. It's returning a #NAME? error. FYI, I am using
Excel 2003.


"Andrew Taylor" wrote:

> Put all the possible characters in a cell, and name it as "list".
> Then
> =MID(list,1+INT(RAND()*LEN(list)),1)
> will give a random character from the list. Use as many of these
> as you need.
>
> Andrew
>
> Tayo wrote:
> > How can I generate random characters (both letters and numbers) into
> > different cells (both rows & columns) at he same time in excel?
>
>

[Andrew Taylor]

"list" is an Excel Name for the cell containing the list of characters.

You could use a cell reference instead, e.g.:

=MID(A1,1+INT(RAND()*LEN(A1)),1)

where A1 contains (say)
1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ


Tayo wrote:
> Is the word 'list' in the formular the name of the header for the list? The
> formular is not working. It's returning a #NAME? error. FYI, I am using
> Excel 2003.
>
>
> "Andrew Taylor" wrote:
>
> > Put all the possible characters in a cell, and name it as "list".
> > Then
> > =MID(list,1+INT(RAND()*LEN(list)),1)
> > will give a random character from the list. Use as many of these
> > as you need.
> >
> > Andrew
> >
> > Tayo wrote:
> > > How can I generate random characters (both letters and numbers) into
> > > different cells (both rows & columns) at he same time in excel?
> >
> >

[Tayo]

Thanks Andrew but I have some other questions:

(1) How can I make sure that the characters generated are not repeated in
any of the cells?

(2) Some cells returns null characters while some others return characters
whose length is less than the specified length in LEN. How can I control the
length of characters the code will return?

Thanks

"Andrew Taylor" wrote:

> "list" is an Excel Name for the cell containing the list of characters.
>
> You could use a cell reference instead, e.g.:
>
> =MID(A1,1+INT(RAND()*LEN(A1)),1)
>
> where A1 contains (say)
> 1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
>
>
> Tayo wrote:
> > Is the word 'list' in the formular the name of the header for the list? The
> > formular is not working. It's returning a #NAME? error. FYI, I am using
> > Excel 2003.
> >
> >
> > "Andrew Taylor" wrote:
> >
> > > Put all the possible characters in a cell, and name it as "list".
> > > Then
> > > =MID(list,1+INT(RAND()*LEN(list)),1)
> > > will give a random character from the list. Use as many of these
> > > as you need.
> > >
> > > Andrew
> > >
> > > Tayo wrote:
> > > > How can I generate random characters (both letters and numbers) into
> > > > different cells (both rows & columns) at he same time in excel?
> > >
> > >
>
>