View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Louis[_3_] Louis[_3_] is offline
external usenet poster
 
Posts: 1
Default Generating Field inputs from other fields


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

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.