How to Combine Contents in Cells in Excel – Tutorial

We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)

Excel tutorial on 4 ways to join cells in Excel. We’ll look at how to use ampersand (&) in Excel, then CONCATENATE, followed by the CONCAT function and, lastly, the TEXTJOIN function.

Ampersand and CONCATENATE are both used in Excel to combine contents cells and are pretty much interchangeable. & is a calculation operator (kind of like other math symbols) and doesn’t require the use of parentheses.

CONCAT is the newer version of CONCATENATE and will very likely replace CONCATENATE in the coming years. CONCAT is also used to combine the contents of multiple cells into one, but can do so a bit easier and faster than CONCATENATE by allowing users to select a range rather than only 1 cell at a time.

The TEXTJOIN function combines cells like CONCAT does, but allows users to enter their delimiter only once in the formula – rather than at each instance.