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: https://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
Watch video Join text in Excel, without CONCATENATE online without registration, duration hours minute second in high quality. This video was added by user David Benaim 26 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 329 once and liked it 15 people.