More of my discussion with Ann K. Emery. This episode talks about TEXTJOIN and how it would be nice to have TEXTSPLIT. Check out Ann’s blog at https://depictdatastudio.com/blog/
More Snippets here:
(0:00) Welcome and intro
(0:30) Discussion about TEXTJOIN and TEXTSPLIT
(1:01) Demo of TEXTJOIN using a range in Excel
(1:35) Generating random Yes/No using RAND in Excel
(1:54) Converting Excel formulas to values by dragging
(2:20) Using TEXTJOIN with an IF Function in Excel
(3:00) The need for TEXTSPLIT
(3:10) Counting names using LEN and SUBSTITUTE
(3:40) Converting Excel data to a paragraph in Word
(4:06) Concatenating text and numbers in Excel loses formatting