Getty Images
The CONCATENATE function in Excel enables users to merge data from multiple cells or columns into a single cell or column. Despite being less recognized than other Excel functions like IF and VLOOKUP, CONCATENATE is still a powerful tool, simplifying data manipulation tasks. For instance, you can combine revenue and profit columns for a specific month into a single cell.
CONCATENATE differs from merging cells in Excel, as it focuses on data analysis rather than formatting.
Let’s explore how to use CONCATENATE effectively in Excel.
Using the CONCATENATE function for two columns in Excel
Step 1: Select the target cell where you want to merge data from other cells. In this example, we’ll use the adjacent column to the source columns.
Image used with permission by copyright holder
How do you concatenate 3 columns in Excel?
You can also use CONCATENATE to combine more than two columns.
How do you concatenate in Excel without a formula?
For more Excel guides, check out our articles on creating graphs and alphabetizing data.
