Get Started With Excel TEXTJOIN Function

In Excel for Office 365, or Excel 2019 and later versions, you can use the TEXTJOIN function to combine text from multiple ranges, quickly and easily.

This is much better than the old methods of combining text with the CONCATENATE function, or the ampersand operator.

In this video, see how to us the new TEXTJOIN function to quickly combine the weekday names from 5 cells. The day names are separated by commas.

Then, see how to add formatting to the combined values, when joining a list of dates with the TEXTJOIN function. Without that formatting, the list shows numbers, instead of easy-to-read dates.

Download the free Excel workbook on this page:

Video Timeline:

00:00 Introduction
00:25 Old Way to Combine Text
00:54 TEXTJOIN - List of Days
02:20 TEXTJOIN With Formatting
02:48 Named Ranges
03:50 Get the Workbook

Instructor: Debra Dalgleish, Contextures Inc.
#ContexturesExcelTips

[sundaysharing]

Simple, excellent, clear explanation. I truly appreciate this video. Thank you.

[wayneedmondson]

Hi Debra. Great tips. TEXTJOIN is super handy. Used to do the same with a UDF. Now, so easy. Thanks for the video! Thumbs up!!

[MalinaC]

Thanks for the awesome TEXTJOIN video :) ♥

[royhampton-eo]

Thanks for the video Debra. I'm trying to use Textjoin with filters to select items from a list with multiple delimiters (a) a line break using char(10) and (b) a dynamic count of the items being joined. Is this possible?

[sandip_bettereveryday]

TEXTJOIN function does wonder when use with Dynamic Array functionalities (like while using TRANSPOSE function) and if we want resultant data in one cell instead of spilling into multiple cells.