Thanks L. This worked great!
KS
"L. Howard Kittle" <lhkittle@comcast.net> wrote in message
news:nLidnVprisDUonjZnZ2dnUVZ_sqdnZ2d@comcast.com...
> Replys to the other post:
>
> English version
>
> Kenny,
>
> Put in A1: 1234567890abcdefghijklmnopqrstuvwxyz
> and in A2:
> ="123"&MID(A$1,INT(RAND()*36)+1,1)&MID(A$1,INT(RAND()*36)+1,1)&MID(A$1,INT(RAND()*36)+1,1)&MID(A$1,INT(RAND()*36)+1,1)&MID(A$1,INT(RAND()*36)+1,1)
>
> Best regards,
>
> Michel BRUYERE
>
>
> Hi Kenny,
>
> Adding to Michel's solution, you can name the formula
> MID(A$1,INT(RAND()*36)+1,1) and thereby shorten the overall formula.
>
> Go to Insert > Name > Define > enter name > Refers to >
> =MID(A$1,INT(RAND()*36)+1,1) > OK.
>
> So if you named the formula X, then your worksheet formula would be:
>
> ="123"&X&X&X&X&X
>
> HTH
> Regards,
> Howard
>
> Maybe those did not get thru to KennyS
>
> "Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in
> message news:313FDD5B-D45E-49EA-99ED-55BE4698B6C6@microsoft.com...
>> Use:
>>
>> =RANDBETWEEN(12300000,12399999)
>>
>> --
>> Gary's Student
>>
>>
>> "KennyS" wrote:
>>
>>> I need to know the formula to create a column of random 8 character ID
>>> numbers, preferably with a set prefix of 3 numbers. I'd be REALLY happy
>>> if
>>> I could create it with random text and numerals, but it doesn't have to
>>> be.
>>>
>>> (where 123 is the constant)
>>> i.e.:
>>> 12386756
>>> 12337288
>>> 12378645
>>> 12321356
>>>
>>> or
>>>
>>> 123g568e
>>> 1237t7er
>>> 12397u23
>>>
>>> Thanks in advance for your help.
>>>
>>> Kenny
>>>
>>>
>>>
>
>