Creating Unique ID from multiple columns

Hi experts,

I need help with the following. I have attached an excel file for reference. I have three fields, A, C and D. I want the unique ID in column B (highlighted). I want the Column B output as shown where the result should be unique and be a combination of column C.D.A . There should be a period in between as Orange.ABC.1 as a unique combination.


Thanks in advance
unique-ID.xlsx
techEverestAsked:
Who is Participating?
 
Rodney EndrigaData AnalystCommented:
This would also give you the same result:

=CONCATENATE(C2,".",D2,".",A2)

You can enter this formula in B2 and drag it down
0
 
Michael FowlerSolutions ConsultantCommented:
Just use a formula

=C2 & "." & D2 & "." & A2

Open in new window


Just enter this formula in B2 and drag it down
0
 
techEverestAuthor Commented:
Thanks both works great.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.