# Unique Number

##### Board Regular
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:

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
1. Should the new reference numbers follow a pattern or be completely random?

2. Do they only need to be unique out of the 20,000 check numbers in your list, or do we need to ensure that future check numbers will have a unique alphnumeric code as well. (in which case I would think we want to have a system)

3. In your example, I noticed you had a few alphabetic characters in the beginning followed by numbers. Is this desired, or would Alphabetic characters throughout be acceptable?

Thanks for the quick response.

1) they can completely be random.
2) We need to have a system because they will be other checks besides the 20,000.
3) Alphanumeric numers through out will beacceptable.

Can someone please ray: ray: help me on this, I am in a very desperate situation for a solution as need something done ASAP

Are your check numbers going to be unique themselves?

Also, do the check numbers have a certain limit on how many characters are within them?

The check numbers can be unique but they do not have to, the reference number for each check shoud be unique though, and they need to be 32 characters long and be alphanumeric.

Would this fit the requirements? B2 (copied down) is:
=REPT("0",5-LEN(ROW()))&ROW()&REPT("A",27-LEN(A2))&A2

Peter;

Your formula works except for the fact that it is check number dependant and hence the reference number is not always 32 characters.

Peter;

Your formula works except for the fact that it is check number dependant and hence the reference number is not always 32 characters.
I believe it is. Here is my sheet again with C2 copied down:
=LEN(B2)

Replies
0
Views
214
Replies
7
Views
306
Replies
5
Views
217
Replies
14
Views
742
Replies
4
Views
523

1,203,514
Messages
6,055,838
Members
444,828
Latest member
StaffordStag

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back