We are in the process of updating the site, so some pages still have the older design.
How to combine text using multiple different delimiters and TEXTJOIN in Excel.
This is a great little trick that allows you to make more concise formulas when you have newer versions of Excel.
Note that the TEXTJOIN() function only exists for Excel 2019 and Excel 365, but that you can use multiple different delimiters in previous versions of Excel if you concatenate by hand, using the "&" ampersand character and specifying the delimiters that should go between each piece of the text - that is not as seamless as using TextJoin, but it will still get the job done.
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Phone number is optional - we use it to send course discounts and weekly updates via SMS.