Function to Generate Random Numbers and Letters

Hi there,

I need your help in designing a custom Macro/Function to automatically generate a series of random number and a separate function to generate a random series of letters.

The syntax would be as follows:

Rand_Num(1,1000) - this function would generate a random series of numbers from 1 to 9999 eg. 6518

Next. I need a separate function to generate a random series of letters. The syntax would be as follows: Rand_Ltr(4,A-Z)

So this function would return four letters that are randomized from A-Z eg. KTMR

Any help with this is greatly appreciated.

Thanks in advance,

Cheers,

Jason

maybe this:

=CHAR(CHOOSE(RANDBETWEEN(1,2), RANDBETWEEN(48,57), RANDBETWEEN(65,90)))

This will give you 50% for getting number or letter.

You can join severl of them to create string.

Or only this for 4 letters:

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))

Thanks very much for all the helpful replies.