How to Have Excel Ignore Numbers

Save

You can use Microsoft Excel formulas to ignore the data in a cell if it is a number. Microsoft Excel is a useful spreadsheet application that's been around since 1985. Excel formulas provide you with the ability to create conditional statements to test if the data in a cell is a number or not. These are called "IF" statements. So in this case, "IF" the data in a cell is a number, it won't return a value. "IF" the data in a cell isn't a number it will return the original value in the cell.

Instructions

  • Open the Excel spreadsheet and select the cell with the data you want to check. Make a note of the name of the cell in the "Name Box" to the left of the "Formula Bar."

  • Select an empty cell you will use to check if the data is a number. It doesn't matter where the cell is in relation to the data cell.

  • Type the following code into this cell, replacing A1 with the cell name of the data cell:

    =IF (ISNUMBER(A1), "", A1)

  • This formula will ignore the data in cell "A1" if its a number.

References

  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet

Comments

Resources

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!