On Feb 9, 2:03 pm, mikep wrote:
I'm trying to convert 12 digit strings to individually unique 4 digit strings
for product coding. Any ideas?

Examples required.

1) Insert a column
2) In the first row put '0000
3) In the second row put '0001
4) Fill down to your hearts content
5) You now have 10000 unique 4 digit ids