klitton7

asked on

# Excel 2010 formulas returning error because users accidentally entered a space in a cell.

I have prepared a census worksheet which contains formulas that refer to other cells. From time to time, users tell me something is wrong with the worksheet because "####" appears in the cell where the formula result should be. I have discovered that somehow they have entered a space in the cell that the formula refers to. Once I delete the space, the formula returns the correct answer.

Is there a way to write a formula so that it it treats a cell that contains a space in it as if it does not exist?

I have attached an example.. in Cell T13 of the "DEC" worksheet, I entered a space.

I would like to prevent users from entering spaces in columns Q thru Y, or else adjust formulas so that spaces are not recognized.

Monthly-2014.xls

Is there a way to write a formula so that it it treats a cell that contains a space in it as if it does not exist?

I have attached an example.. in Cell T13 of the "DEC" worksheet, I entered a space.

I would like to prevent users from entering spaces in columns Q thru Y, or else adjust formulas so that spaces are not recognized.

Monthly-2014.xls

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER