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 🙂
Category: Excel
This category contains information relating to Microsoft Excel
Excel: Entering a Carriage Return in a cell
I have just found out, that if you want to enter a carriage return into an Excel cell, just press Alt+Enter 🙂
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.
Excel: Error “HRESULT 0x800A03EC” when outputting data to Excel
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 […]