TEXTJOIN with Different Delimiters at Once in Excel
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.
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Tutorial: How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsh...
Tutorial: How to quickly resize multiple columns and rows at once in Excel. This avoids having to...
Tutorial: How to print all worksheets at once from Excel. This saves you the time of having to go to...
Tutorial: View different sections of the same worksheet when the sections are far apart. This all...
Tutorial: Have one simple formula that will reference the same cell or range of cells on multiple w...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)