Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

To merge or combine the first and last names in Excel you can make use of the CONCAT Ampersand, Flash Fill or TEXTJOIN functions or formulas.

I don’t normally blog about Excel topics outside of Power Query and Power Pivot, but I think anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more than ...

CONCATENATE function is available across multiple versions of Excel up to Excel 2019. However, it is being phased out in favor of CONCAT and TEXTJOIN functions introduced with Excel 2016.

Want to join multiple cells of text together into one? Learn how to use the concatenate function in Excel to easily combine multiple text strings into one.

How to combine values into a single cell using TEXTJOIN () in Excel Microsoft 365, Excel 2019 and Excel for the web support the function, TEXTJOIN ().

CONCAT and TEXTJOIN were added to Excel in 2019, so if you're using an older version, you might not have access to these functions.