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.
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…