combined 3 number cells into 1 text cell

[frankday]

I am looking for a formula that takes 3 columns of numbers and make then one text. Example column A is 2, column B is 12 and Column C is 1. I want it to fill in Column D with "2-12-1" as a text.

 

[VBA Geek]

D2 = a2 & "-" & b2 & "-" & c2

 

[Rick Rothstein]

I am looking for a formula that takes 3 columns of numbers and make then one text. Example column A is 2, column B is 12 and Column C is 1. I want it to fill in Column D with "2-12-1" as a text.

With only three values, I would just concatenate those values and delimiter together...

=A1&"-"&B1&"-"&C1

 

[frankday]

Got it figured out.