If you have a list of values in Microsoft Excel and need to create an IN clause for a WHERE statement in SQL Server or for the criteria field in Microsoft Access. Check out this article where we share our formula and/or VBA code for this.
Read More
In this article we discuss how to fix the problem which causes Excel to produce the error message “Personal Macro Workbook in the startup folder must stay open for recording”.
Read More
In this article we discuss the 3 reasons which cause the ISBLANK function to return false when a cell appears to be empty.
Read More
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.
Read More
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.
Read More
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.
Read More
If your Excel file contains sensitive data, you may want to password protect it. In this article, we walk you through the steps to password protect your Excel file in Excel for Windows and Excel for Mac.
Read More
Knowing how to identify precedent cells is an invaluable skill for auditing and understanding spreadsheets. We share some tips and tricks on how to efficiently identify precedent cells.
Read More