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: Microsoft Excel
I have just found out, that if you want to enter a carriage return into an Excel cell, just press Alt+Enter 🙂
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.
Sometime ago, I wrote a Query Tool application that output data from a database into Excel. However, in the past few days, the users have been getting the “HRESULT 0x800A03EC” exception error when running a specific query. I knew that the application was working, because other query data was being output to Excel. I decided […]