Join 2 Cells into 1-Concatenation

Download example
ExcelMagicTricks01-10.xls

Description
Easily join two columns of data into one column. It’s called Concatenation. And we will use the join operator “&” to create a Text formula! Yes that is right, formulas are not just for numbers anymore! Also, see how to double click the fill handle to copy a formula down quickl

Comments are closed.