The separator will be included between the merged data. You can also use a separator (unlike comma, space, or any other symbol) between the quotation marks ” ” in the formula. In the second cell of the column (our case its C2), write the below given Excel formula for concatenating two columns.įormula used: =CONCATENATE (cell reference 1,” “, cell reference 1)Īs we have the first name in E7 and last name in F7 so we will refer to these cells.
#HOW TO MERGE 2 CELLS IN EXCEL WITHOUT LOSING DATA FULL#
Insert a helper column into your Excel table and name the newly added column as “Client Full Name”.This function helps to combine the data of two columns into one.įollowing are the steps to merge two columns using Excel CONCATENATE formula: The method is by using Excel CONCATENATE() formula. Now, you need a table merging both the information into one (Full Name). In the below example as you can see we have two different columns consisting Client’s first name and client’s last name. Join columns using the Excels’ Merge Cells add-in suite.Combine different columns data via Notepad.
In this tutorial we will cover the different ways to join two different columns in Excel. (refer to the below screenshot)Īs soon as you click on the Merge cells option Excel will immediately throw an error message displaying “Merging cells only keeps the upper-left cell value, and discards the other values.” Therefore people don’t use this method much as they might lose some valuable data. Though, it provides a Merge button (“Merge & Center” etc.), but it only helps to join 2 adjacent cells. Unfortunately, Excel does not have any predefined formula to implement the merger of two columns. The fetched information comes in a raw format and often needs to be organized exactly as per the user’s requirements and industry standards.įor example, the user wants to join the First Name & Last Name columns into one column and want to use a separator between them. While importing your data from various database sources is something every Excel user owner will need to do eventually. From data operators to business owners, everyone needs to merge or join two columns together in Excel.