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.
Solved! Go to Solution.
Try CONCATENATE(“DXB”,UniqueID())
User | Count |
---|---|
16 | |
13 | |
8 | |
7 | |
4 |