I don’t know how many times I’ve had the need to merge content from multiple cell tables, but at this point I can’t set better reasons for merging first and last names in one column.
You can do the fastest way to merge content from two or more cells with the ampersend [&] operator. And the syntax is simple, just apply it to the cell where you need the result.
=A1&B1&C1&D1
You can do the same job and use the CONCATENATE formulas.
From the Excel 2019 version, we also have a significant improvement using the CONCAT formula.
Old formula CONCATENATE
=CONCATENATE(A1;B1;C1;D1)
Each cell must be specified separately as a variable.
New CONCAT formula
=CONCAT(A1:D1)
Some limitations have been overcome in the new formulas, so that the whole range of values can now be covered without special mention.
We will definitely expand on this story, if you have the needs.