Creating_a_unique_ID_using Excel's text functions and randbetween()

[@artemphilimonov9974]

thank you! you help me a lot! I spent a hour to solve my problem and your video resolved it in one second

[@TheExcelLady_Ireland]

Ah, I am so happy about that - thank you for letting me know

[@christibatista7205]

Found this very useful! Thank you!

[@TheExcelLady_Ireland]

delightful

[@mebetancourt01]

This is a great video, could you please (if possible) guide on how to create a unique ID eg. 001 across several tabs in the same excelsheet?

[@TheExcelLady_Ireland]

hi Elizabeth can I just clarify - you mean creating a unique set of identifiers that goes across a number of worksheets? If so in that case what I would suggest would be to create them ALL on one sheet and then use Copy | Paste Values to put them in the different worksheets. If that's not what you have in mind - give me a bit more detail and I will see what I can suggest :-)

[@sofiadragini3359]

Hello,your video was very helpful but I would appreciate if you could tell me how to insert this symbol (-) between the initials and the numbers.

[@TheExcelLady_Ireland]

What you could do is simply insert another column with the - in it between Random # and First Name 1st. That is now Column I, Then amend the formula in Unique ID to include this. It should then read =H4&I4&J4&K4&L4&M4. That should do it. :-)