I have column full of different Customer Names.
I need to create corresponding column that contains a code for the customer of the first three digits of their name and a two digit sequential number.
Example:
Advanced Concepts - ADV01
Also if there is a repeat of the first three digits then...