Only for questions on programming against Excel objects or files, or complex formula development.
There are many, many questions and quality answers on SO regarding how to prevent leading zeroes from getting stripped when …excel padding
How do I express the condition "if value is not empty" in the VBA language? Is it something like this? "…excel vba
I want to get the content of a cell given its row and column number. The row and column number …excel excel-formula
I have a workbook with 20 different pivot tables. Is there any easy way to find all the pivot tables and …excel vba refresh
How can I construct the following string in an Excel formula: Maurice "The Rocket" Richard If I'm using single quotes, …excel excel-formula
I'm developing a part of an application that's responsible for exporting some data into CSV files. The application always uses …excel csv utf-8