Enter in B1 and copy down as far as needed:

=LEFT(A1,3)&CHAR(INT(RAND()*25+65))&CHAR(INT(RAND( )*25+65))&CHAR(INT(RAND()*25+65))&D1

"Louis" wrote:


--------------------------------------------------------------------------------

Hi,

Is it possible to generate a 8character code from the inputs in other
fields, I'd really like to be able to do something like the following:

A1 - Jims Field
D1 - 1 (category)

B1 code:

[A1 CODE-FIRST 3 LETTERS][4 RANDOM CHARACTERS BETWEEN A-Z AND 0-9][D1 CAT ID
1]

Can this be done? I have no idea where to start.