Combine values in columns

Occasional Visitor

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 Replies

@Devratio 

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

minus.JPG

 

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

 

NikolinoDE

@Devratio 

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

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