Kenny,

Are you looking for a list of numbers that have no repeats?

It can start with ="123" & (something) but I think it'll have to be vba to
enure no repeats.

Beege

"KennyS" <ks4078@hotmail.com> wrote in message
news:FuWdncuNlP0AzHnZnZ2dnUVZ_uidnZ2d@adelphia.com...
>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
>
>