The syntax of the CONCAT function is as follows: Let’s first try to see the syntaxes of both these functions and then we will see some examples: CONCAT Function CONCAT is a relatively new function that has replaced the older CONCATENATE function from Excel 2019 onwards.Īlthough, the CONCATENATE function has been made obsolete however it still exists in Excel 2019 and Office 365 for backward compatibility. On the other hand, concatenation takes data from the selected cells and combines it in a separate cell (where concatenation functions or concatenation operators are used).ĬONCAT and CONCATENATE functions In ExcelĬONCAT and CONCATENATE are the two functions available in excel for concatenation. Lionel) in the merged cell and the Last name value was discarded. All the other cell values are discarded.Īs you can see above, by merging the First name and Last Name cells we are only left with the First name value (i.e. Let’s understand this with an example, as you may see in the screenshot, merging cells will combine the cells by only retaining the left-most value in the merged cell. Merging joins two or more cells to form a new, bigger cell, but the merged cell data would only be the left-most cell's data.
![concatenate excel concatenate excel](https://www.lifewire.com/thmb/uoxG69TT02CH9gk44kzFn-rGM8k=/1366x722/filters:no_upscale():max_bytes(150000):strip_icc()/excel-concatenate-combine-cells-3r-5c6e97ba46e0fb0001e6e859.jpg)
Merging cells does not mean combining data, it means combining cells. How Concatenation Differs from Merging CellsĪlthough both the operations (concatenating cells and merging cells) look somewhat similar, yet the results they yield are very different. In this post, we are going to have a look at all those functions and operators and try to understand them.īut before going ahead, let’s try to understand the difference between concatenation and merging. So to generate data for the ‘full name’ column, we can make use of a string concatenation function such as CONCATENATE to combine ‘First name’ and the ‘Last name’ and show that result in the ‘Full Name’ column.īesides the obvious CONCATENATE function, there are a few other inbuilt functions and operators that Excel provides to concatenate data. Now let’s say, we want to have another column ‘Full Name’. Let’s try to understand concatenation with a simple example.Īs seen in the screenshot above, we have a spreadsheet with ‘First name’ and ‘Last name’ columns.
#Concatenate excel how to#
![concatenate excel concatenate excel](https://cdn.educba.com/academy/wp-content/uploads/2019/06/Opposite-of-concatenate-in-excel.png)