I would like to create an automatic unique Id number in cell A1, the data would come from B1, C1 and D1. B and C are numbers and D is text. The cell data looks like this B1=20, C1=24, D1=GVI. The auto number would look like this 2024GVI. I have tried several ideas but get errors since I have a text field.
I appreciate any help
I appreciate any help