Combine values in columns

Occasional Visitor



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?



2 Replies


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



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





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