Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.