Forum Discussion

Copper Contributor

Jun 19, 2020

Unique Reference numbers

I need to create unique reference numbers in a specific alphanumeric sequence such as ABCDEF/201**D with the starred section changeing each time. What formula can I use to do this?

excel

Formulas and Functions

HHolley185

Copper Contributor

Jun 19, 2020

Hi peteryac60

no that was spoy on the ** is the only bit that needs to change, thanks for the attachment.

peteryac60

Iron Contributor

Jun 19, 2020

You are welcome!

Can you please mark this as best solution?

Thanks!