Help with an alpha/numeric random number generator

[klewis]

Help with an alpha/numeric random number generator 6 to 12 charaters

 

[acw]

Hi

This is going to give you some punctuation characters but may get you started.

=LEFT(CONCATENATE(CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90)),CHAR(RANDBETWEEN(48,90))),RANDBETWEEN(6,12))

Tony

 

[Yogi Anand]

Help with an alpha/numeric random number generator 6 to 12 charaters

Hi klewis:

In the following, I had a little play with what you are trying to do ...

Book1
	A	B	C	D
1
2	2	3	6
3	10	K	3K777K
4	6	7
5	6	7
6	6	7
7	10	K
8	1	2
9	1	2
10	11	L
11	14	O
12	10	K
13	13	N
14
Sheet6

I used two helper columns A and B for some intermediary values. Would something like this work for you?

 

[NateO]

Hello,

Another possibility:

http://www.mrexcel.com/board2/viewtopic.php?p=846956#846956