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
Excel: Remove HTML Tags and Escape Codes from an Excel selection
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.
Access: Remove “dbo_” prefix from imported tables
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 🙂
VB: Retrieve the header row column names from a text file
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”.