Combine values in columns

[Devratio]

Hi,

Beginner question, I want a number value for example in

Column A: 100

Column B: 50

Column C: 20

to create a new column D that displays the values in this specific format: 100-50-20

How can I do this?

Thanks!

[#2]

@Devratio 

I'm not sure if this is it, but here's an example.

If it's just to show: =A1&"-"&B1&"-"&C1

NikolinoDE

[#3]

@Devratio 

=CONCATENATE(A1,"-",B1,"-",C1)

If you want to return " 100-50-20 " in cell D1 you can apply above formula.