Excel Forum



Excel Magic Trick # 9: Join 2 Cells into 1


Excel! See how to take two columns of data and join them into one column! This process is 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 quickly.





Got a Question? Ask it Here in the Forum.