Thanks Max
Would never have got there by myself !!

"Max" wrote:

One play ..

Put in any cell, copy it down / across as desired:
=CHAR(randbetween(65,90))&randbetween(1000,9999)

Above will return random strings comprising of a capital alpha between A -
Z, concatenated with a random 4 digit number between 1,000 and 9999, eg:

N9484
L7773
F3785
Y1198
C5555
etc

Pressing F9 re-generates. Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michelle B" wrote:
Is it possible to create alphanumeric random numbers ?