Create formula that will merge data in multiple columns (A, B, C and D) in that order

watermt69

New member
Joined
Nov 19, 2014
Messages
11
Reaction score
0
Points
0
Excel Version(s)
2010
I need to create a formula that will merge data in multiple columns (A, B, C and D) in that order. It should also yield an Equipment ID# that looks exactly like the text in the highlighted cell of the attached spreadsheet. I'm being asked to ensure the leading zeros (0) show in the Equipment ID# automatically. Then I'm to copy the formula down from E2 to E83 (this I believe I can handle.

Can anyone assist me on this task?
 

Attachments

  • Book3.xlsx
    13.8 KB · Views: 11
=Table1[@Building]&"-"&Table1[@Equipment]&"-00"&Table1[@Number]&"-"&Table1[@Location]
 
Try:
=TEXTJOIN("-",,A2,B2,TEXT(C2,"000"),TEXT(D2,"000"))
or
=A3&"-"&B3&"-"&TEXT(C3,"000")&"-"&TEXT(D3,"000")
 
Works like a charm, thanks a million!
 
The second formula worked very well, but all I could get returned for the first formula was #NAME?. Even after making sure the row numbers lined up correctly.
 
Thanks for the clarification and assistance.
 
Back
Top