Random function - alpha/numeric

  • Thread starter Thread starter ghobbit
  • Start date Start date
G

ghobbit

Hi

I'm a bit of a newbie to excel and am having a problem with generatin
a random alpha-numeric figure.

I need to generate 30 random figures from a list between aa0000 an
aa1000. I know I could just use the numbers (0000,1000) in the ran
function but without going into details I cant do that.

I have looked at the =randbetween(x,y) function and entered
=randbetween(aa0000,aa1000) but without success - all I got was #NAME.

Is there some other way that I could this perhaps a combination o
functions preferably not going into VBA as I'm not a programmer an
wouldnt have a clue.

any advice would be most appreciated.

many thanks

stev
 
Not sure if this is what you want, but try
="aa"&INT(RAND()*1000)
aa could be in a cell so if it were in A1
=A1&INT(RAND()*1000)
 
Many thanks to you all - I tried all the suggestions and they al
worked.

thanks again

stev
 
Back
Top