Important: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel. Example Copy the following example to a blank worksheet. 1 2 3 A B First Name Last Name Nancy Davolio Andrew Fuller Formula Description (Result) =A2&' '&B2 Combines the names above, separated by a space (Nancy Davolio) =B3&', '&A3 Combines the names above, separated by a comma (Fuller, Andrew) =CONCATENATE(A2,' ',B2) Combines the names above, separated by a space (Nancy Davolio).
How to Combine Excel Sheets With a Click. Now, a new window pops up with the list of files we're set to combine. At this stage, you're still seeing metadata about the files and now the data itself. To solve that, click on the double drop-down arrow in the upper right corner of the first column.
In some situations, Excel will help you merge cells automatically. This can save a lot of time if you need to merge the same types of data repeatedly.
Let’s take a look. We’ll use the Employees sheet (the second sheet in the workbook) again. Delete any values from the Full Name column before you start. Click into cell C2, and type “Noella Bridgen.” This is the concatenation result that you’re looking for. Next, click into cell C3, and start typing “Rosana Ellin.” As soon as you start typing, Excel will fill in the cell with its best guess at what you want, and will show you a preview of what the rest of the entire column would look like if you used that type of concatenation.