Use Excel TEXTJOIN Function to Combine Text With Conditions
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.
To see a simple TEXTJOIN formula, watch our "Get Started with Excel TEXTJOIN Function" video
• Get Started With Excel TEXTJOIN Function
In this video, Sarah shows how to add a condition with TEXTJOIN, so only the weekdays that are marked with X are included in the combined text.
To get the Excel workbook, with the Excel TEXTJOIN Function to Combine Text With Conditions example, go to this page on my Contextures site:
https://www.contextures.com/xlcombine...
Or use this short link: myctx.link/TJoin
00:00 Introduction
00:17 TEXTJOIN Function
00:27 Simple TEXTJOIN Formula
00:58 Start the Formula
01:30 Check for an "X"
01:45 Add a Condition
01:55 What to Show
02:15 Formula Result
02:22 Get the Workbook
Instructor: Sarah, Contextures Inc.
Contextures.com founder: Debra Dalgleish
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips