Using Excel's Textjoin function to combine text

Posted on
6,005 Points
Last Modified:
Experience Level: Intermediate
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
Excel has always done a good job of exporting lists to comma-separated values (CSV files). Starting with the 365 editions, it can also create CSV lists inside the cells of a worksheet. And the data in the lists don’t have to be separated with commas. You can separate them with any delimiter you want, like spaces, colons or semicolons. In this episode, we use the Textjoin function to take a list of names and addresses and turn them into a column of CSVs.
Author:Bob Flisser

Suggested Videos

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Storing hashed or encrypted data.
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html).  I have realized that my coworkers primarily use Excel and So have changed the ar…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month