This category contains information relating to Microsoft Excel
I wanted to add leading zeroes to a number column, making a seven-digit number. I found the REPT function:
=IF(LEN(A2)>7,A2,REPT("0",7-LEN(A2))&A2)
If the cell is longer than 7 digits, it puts the whole cell value in. If it is 7 or less, it will “repeat” the zero the required number of times.
Hope this helps 🙂
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 🙂
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 […]
SQLblog.com SQL Server Team Blog