Combine two columns in Excel (Step-by-step tutorial)

When working with Excel, you may encounter situations where combining two columns becomes necessary to improve data organization and facilitate your work. In this tutorial, we will guide you through the process of combining two columns in Excel, whether you want to concatenate text, merge dates, or combine numerical data. Let's get started!

0:00:00 Intro
0:00:14 Combine two columns with ampersand (&)
0:01:36 Merge columns quickly with a versatile tool
0:02:56 Combine two columns with Excel concatenating functions
0:03:52 Correctly display formatted numbers with TEXT function
0:06:25 Correctly display formatted numbers with Kutools’ Use Formatted Values option
0:07:52 Correctly display formatted numbers with Notepad