I needed to remove carriage returns, line feeds and tab characters from an Excel spreadsheet that was copied straight out of Microsoft Access, and have written a script that performs the replace. Just change the option accordingly, and run 🙂
Tag: Visual Basic
The code in this post can be used to remove HTML tags and escape codes from an Excel selection. Simply page the code into a new module, select the relevant cells to be processed, and press run.
The Microsoft Access procedure contained within post, can be used to remove the “dbo_” prefix from all imported tables within a Microsoft Access Database. Saves doing them all by hand 🙂
The code within this post, is an example of how to retrieve the column/field names from the header row from a text file, and add them to a “ListBox”.