The ISBLANK function in Excel returns TRUE for empty cells and FALSE for non-blank cells. But sometimes, it may not work in excel. So, let us understand the reasons with an example. Consider the table with values in column A. Now, we need to find the blank cells in excel. The steps used to find blank cells in excel are as follows: Step 1: First, select the cell where we want to display the result. So, in this case, it is B2. Step 2: Next, enter the formula in cell B2. So, the complete formula is =ISBLANK(A2) Step 3: Then, press the Enter key. Though cell A2 looks empty without any visible content, the function has returned FALSE because there is space in the cell. Similarly, the function may not work properly. So, we must check the following: 1. Check for extra spaces in-between formulas. 2. Treat 0-length strings as blank cells. 3. Make sure the cells do not have any spaces.