CODEWITHSUNDEEP
databaseexcel
Arun Karthick
Arun Karthick

Reputation: 336

Unique ID generation in MS-Excel

I need to create an unique ID in an excel sheet with the combination of values from other columns. enter image description here

The ID should be like IP-(First three letters of column B)-(Random 4 digit number)-(First three letters of column D)

Upvotes: 0

Views: 193

Answers (1)

Nitesh Halai
Nitesh Halai

Reputation: 927

Use this. It gives the ID no. as in your screen shot.

="IP"&"_"&LEFT(UPPER(B2),3)&"_"&TEXT(ROW()-1,"0000")&"_"&LEFT(UPPER(D2),3)

Upvotes: 2

Related Questions