Hello,
I am looking to create a unique Customer ID using 1) 8 digits and an optional single letter at the end, 2) with dashes after the third and fifth digits, and 3) ensure there are no duplicates. For example, "12345678A" would be shown as "123-45-678A" with no duplicates allowed. Or, "12345678" would be shown as "123-45-678" with no duplicates allowed.
I would like to avoid combining two cells, if possible.
Bookmarks