1. Computing

Excel ISBLANK Function

Find out if Cells are Blank with the ISBLANK Function

By

Excel ISBLANK Function

Excel ISBLANK Function

© Ted French

Excel’s ISBLANK function is one of a group of IS functions or “Information Functions” that can be used to find out information about a specific cell, worksheet or workbook.

The ISBLANK function's job is to check to see if a certain cell is does or does not contain data. If the cell is empty, a value of TRUE is returned by the function.

If it is not empty, the function returns the value of FALSE.

If data is later added to an empty cell the function will automatically update and return a FALSE value.

The syntax for the ISBLANK function is:

= ISBLANK ( Value )

Value: (required) - refers to the value or cell that is being tested.

This argument can be blank, or it can contain data such as text, numbers, error values, logical values, or non-printing characters.

It can also contain a cell reference or named range pointing to the location in the worksheet for any of the above types of data.

Example Using Excel's ISBLANK Function:

As shown in the image above, this example checks to see whether certain worksheet cells do or do not contain data.

Entering the Data

  1. Enter the following data into the following cells:
      D1 - 3
      D2 - leave this cell blank
      D3 -  text
    

Entering the ISBLANK Function

  1. Click on cell E1 to make it the active cell - this is where the results of the function will be displayed

  2. Click on the Formulas tab of the ribbon

  3. Choose More Functions > Information to open the function drop down list

  4. Click on ISBLANK in the list to bring up that function's dialog box

  5. Click on cell D1 in the worksheet to enter the cell reference into the dialog box

  6. Click OK to complete the function and close the dialog box

  7. The value FALSE should appear in cell E1 because cell D1 is not empty

  8. When you click on cell E1 the complete function = ISBLANK ( D1 ) appears in the formula bar above the worksheet

Copying the function using the fill handle

To save time, we can use the fill handle to copy the ISBLANK function in cell E1 to cells E2 and E3.

  1. Click on cell E1 to make it the active cell

  2. Place the mouse pointer over the black square in the bottom right corner of cell E1. The pointer will change to a plus sign " + "

  3. Click the left mouse button and drag the fill handle down to cell E3

  4. Release the mouse button. Cell E2 should contain the result TRUE since cell D2 is blank and E3 should return FALSE since cell D3 contains the word text

Invisible Characters and ISBLANK

In the image above, the ISBLANK function in cell E4 returns a FALSE value even though cell D4 appears to be blank.

This is not an error because cell D4 contains an invisible character called a non-breaking space (&nbsp).

Non-breaking spaces are one of a number of control characters commonly used in web pages and these characters sometimes end up in a worksheet along with data copied from the web page.

Removing Non-breaking Spaces and other Invisible Characters

If there is no visible data in the cell, removing invisible characters can usually be accomplished simply by clicking on the cell in question and pressing the Delete key on the keyboard.

On the other hand, if you ever have a situation where a cell contains good data as well as non-breaking spaces, it is possible to strip non-breaking spaces from the data you wish to keep.

©2014 About.com. All rights reserved.