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