TEXTJOIN Function || Combine Texts in Excel

Описание к видео TEXTJOIN Function || Combine Texts in Excel

This video highlights the versatility of the TEXTJOIN Function, which allows you to combine texts from multiple cells or ranges, with an option to separate them with any delimiter that you specify. This function is available in Excel 2019 and later versions.

Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks!

Content
00:00 Intro
00:40 Basic Textjoin
02:33 Textjoin with multiple delimiters
04:18 Conditional Textjoin with IF and FILTER functions
06:26 Conditional Textjoin with empty cells

Connect with me on:
👉Instagram   / youexceltutorials  
👉Facebook   / youexceltutorials  
👉Twitter   / youexceltutor  
👉 TikTok   / youexceltutor  
👉LinkedIn   / bunmi-sanusi  

🎬Check these videos:
Filter Function    • Filter Function vs Advanced Filter ||...  
Unique Function    • Extract Unique Items from a List in E...  
Alternatives to Nested IF    • Alternatives to Nested IF Formulas ||...  
Excel Functions    • Excel Functions  

🔽Download the file here https://docs.google.com/spreadsheets/...

📢”Protect me, God, because I depend on you” Psalm 16:1 (ERV)

#msexcel #youexceltutorials

Комментарии

Информация по комментариям в разработке