Excel provides a lot of solutions for every problem you might face with. We can do a lot of inspection of cells, ranges, worksheets, and workbooks.

In the example below, we will show how to do the inspection on a **level of cells**. We will check if a **certain cell contains space**.

## Check if a Cell Contains Space in Excel

To find a space in a particular cell in Excel, we need to use formulas. Because we have a specific condition, this means we will use the **IF function**, and combine it with other formulas. We will create the **link for Google** but insert the space before typing the domain (.com) in **cell A2** and then insert the correct link in **cell A3**. This is what it will look like:

In **column B**, we will insert our formula, which will be a combination of **IF, ISNUMBER, and FIND**:

1 |
=IF(ISNUMBER(FIND(" ", A2)), "Space Found", "No Space") |

This formula checks if there is an empty space in a cell (in this case, **cell A2**) and returns **“Space Found”** if there is space in our cell, and **“No Space”** if there is no space in the cell and the text in it.

When we insert this formula in **cell B3** as well, these are the results we will get:

We can also replace the **FIND formula with SEARCH** in our example. We will do this with the **links for Amazon** (we will insert two links- one with the space, and one without, in **column A**), and will use the following formula:

1 |
=IF(ISNUMBER(SEARCH(" ", A4)), "Space Found", "No Space") |

We will get the same results as with the **FIND formula**:

We can also combine **IF with** **the COUNT formula** to achieve the same thing. For this, we will use **“* *”** as a criterion, which means that we are counting all the instances of spaces that exist in our cell. If there are any, we will show **“Space Found”**. Otherwise, we will show **“No Space”**: