Creating Custom Unique ID starting with your intials

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.

Try CONCATENATE(“DXB”,UniqueID())

3 Likes

Thank you, It worked! @1minManager

2 Likes