Say a column named TransactionID consists of 13 characters. ( EXCEL) I need ta function that will create this unique Tra

[answerhappygod]

Say a column named TransactionID consists of 13 characters. (
EXCEL)
I need ta function that will create this unique
TransactionID.
First four characters: A combination of any four numbers
of the alphabet (A-Z,a-z).
The second group of four characters: The first four
characters of the student number (0-9).
Dash between the second and third group of characters.
Next group of 3 characters: Random number between 100 and
999.
Last number: Control number: The remainder when
the last group of 3 numbers, is divided by 7. For
example: 187 div 7 = 26 and the remainder is 5.
Example:
A student number: 38456639
The typical example of the TransactionID will
be: AbXy3845-1875