What to do when a cell appears to be blank but the ISBLANK function in Excel returns FALSE

In this article we discuss the 3 reasons which cause the ISBLANK function to return false when a cell appears to be empty.

Microsoft OfficeEasy Adulthood21 June 2021Microsoft Excel, Excel Tips and Tricks, Data Tutorials, Data Validation, Excel Data Sets, Excel Data Analysis, Excel Tutorial, Empty Cells Vs Blank Cells, Zero-length strings Comments

What to do when Excel opens a blank screen and all of the options are greyed out

If you’ve opened an Excel file but it’s not displaying any data and all you can see is a blank screen then check out this article.

Microsoft OfficeEasy Adulthood4 June 2021Microsoft Excel, Excel Tips and Tricks, Data Tutorials, Data Validation, Excel Data Sets, Excel Data Analysis, Excel TutorialComment

What to do when Excel’s TRIM function is unable to remove spaces

If the TRIM function is unable to remove the spaces from a cell, it’s likely the cell contains non-breaking spaces. In this article we share four formulas which remove non-breaking spaces from a cell.

Microsoft OfficeEasy Adulthood4 June 2021Microsoft Excel, Excel Tips and Tricks, Data Tutorials, Data Validation, Excel Data Sets, Excel Data Analysis, Excel Tutorial, TRIM function Microsoft Excel, Excel Trim Function Not WorkingComment

Excel Formula to Verify If National Insurance Numbers (NINOs) Are Valid

If you have a set of National Insurance Numbers (NINOs) and need to check if they are in the correct format, then check out this article. We’ve written the perfect formula for validating NINOs.

Microsoft OfficeEasy Adulthood8 July 2020Microsoft Excel, Excel Tips and Tricks, Data Tutorials, Data Validation, Excel Data Sets, Excel Data Analysis, Excel Tutorial Comments