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.
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.
- Photo Credit Stockbyte/Stockbyte/Getty Images