Creating Custom Unique ID starting with your intials

[sainikhushdeep]

So, How do I get custom Unique ID like starting with DXB…
Like I have Google sheet it has diffrent tab named with city. So for each tab I want Unique Id starting with city codes then random unique no. For example NYC21343.
Thank You.

[1minManager · Accepted solution]

Try CONCATENATE(“DXB”,UniqueID())

[sainikhushdeep]

Thank you, It worked! @1minManager