Category Archives: Excel

Remove non-breaking space from Excel (Filter Cell Value)

Reference:

Create and Download CSV File on The Fly

Reference:

Keep Leading 0 of Numbers in Excel

By default, the leading 0 will be removed if the value is a number:

Solution:

Reference:

Count In Some Condition

Count only when the cell value if bigger than 0 from M5 to Q5: