treat text as blank

[Reggie1000]

is there a way to have text in a spreadsheet treated as blank - I paste in
yachting elapsed times to do some calculations but the cells with DNC cause
problms. Can i run a formula to treat or convert them to blank fields?

 

[Sheeloo]

You can test the cells within your formula with ISTEXT or ISNUMBER to avoid
the errors... we can help more if you can share the formula you are trying to
use...

 

[Dave Peterson]

Maybe the formula that uses those cells should be changed.

Instead of:
=a1+a2+a3
you could use:
=sum(a1:a3)

=sum() will ignore text.

Or if you wanted to treat the text as 0's, you could use something like:
=n(a1)+n(a2)+n(a3)