3] Use the Excel TEXTJOIN Function. Another function good enough for combing names in a spreadsheet is no other than TEXTJOIN.Before going forward, this function is more complicated to use than ...

TEXTJOIN function is available in Excel for Office 365, Excel 2019, and Excel 2021. The syntax of the TEXTJOIN function is as follows: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) ...

An Excel spreadsheet containing the CONTACT function with spaces and the resultant output. An Excel spreadsheet containing the TEXTJOIN function to add the word 'and' between each argument.

If you have Excel 2019 or Excel 365, you can use the function TEXTJOIN to quickly join text in one cell and separate the text with any ... You can view a video demonstrating this technique at the ...