I have this formula A1-B1 which is giving me - in the cells where A1 and B1 is both 0.00. This is affecting my std dev formula. If I replace this with #N/A, it still does not solve the issue.

How do I replace - to blank cells via a formula in Excel?

When I copy and paste special (values) - to another cell it gives me 0.

CodePudding user response：

You could use SUBSTITUTE(CELL_WITH_MINUS_SIGN,"-","")

CodePudding user response：

I think it is easier to just use Find and Replace in Excel. CTRL H and type "-" in Find Whatand Replace All with an empty field.