11:47
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.
0 Comments
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Using Excel's auditing tools | 2 | |
| Installing and Using Excel Add-Ins | 2 | |
| Using Excel's Lambda Function | 9 | |
| Using Excel's New Image Function | 0 |
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…
Suggested Courses
Next Video:Using Excel's Lambda Function