Unique Number

[nnadimi19]

I have a column that has check numbers (20,000 check numbers) I need to create another column that assigns a unique refrence number for each check. The requierment is that it has to be exactly 32 characters long and it can have a combination of alphabets and numbers. The alphabets have to be in upper case.

example

check Number unique number
12345 A0124578896333347852124758589621
65879 D0124578896333347852124758501589


any help will be highly appreciated. ray: ray: ray:

 

[nnadimi19]

Peter;

You are absolutely right, it was an error on my path.

Thanks you ray: ray: ray: