Help with an alpha/numeric random number generator

klewis

New Member
Joined
Jun 23, 2004
Messages
14
Help with an alpha/numeric random number generator 6 to 12 charaters
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
klewis said:
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
ABCD
1
2236
310K3K777K
467
567
667
710K
812
912
1011L
1114O
1210K
1313N
14
Sheet6


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

Watch MrExcel Video

Forum statistics

Threads
1,119,142
Messages
5,576,318
Members
412,716
Latest member
thviid
Top