Join text in Excel, without CONCATENATE

Often you want to join together text in cells together in Excel or join it to custom text. In this video I show you various ways to acheive it including adding text, adding text to numbers/dates or using a SUM like function to create a comma delimited list in a single cell, and then a SUMIFS version and how to ignore duplicates.
You can download the example files here: www.xlconsulting-asia.com/you...
00:00 Introduction
00:27 Using &
01:23 Combining & keeping date/number formats
04:17 ARRAYTOTEXT
04:40 =TEXTJOIN
05:22 UNIQUEs
06:11 TEXTJOIN by category

[@MrTerryRay1]

This is the best practical use explanation about joining text in Excel. Thanks.

[@learnspreadsheets]

Wow that’s really kind! Thanks for the feedback!