How to Remove Blank Rows in Excel?

Blank or empty rows in between a dataset can be cumbersome to look at and work on. We often encounter this type of format with datasets exported from a system or a database. With the blank rows in between, it’s hard to go over the data as you are forced to scroll down just to … Read more

How to Remove Leading Zeros in Excel?

Small green triangles on the left side of cells appear whenever the cells contain numeric values but are formatted as text

Excel, by default, automatically removes leading zeroes whenever you enter numbers. So, you might be wondering why there are leading zeroes in the Excel file you received. Well, there are two possible reasons for that. It could be because: This can happen if there’s an apostrophe at the start of the cell. Apostrophe (‘) is … Read more