treat text as blank
 

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?
--
PT

treat text as blank
 

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...

"Reggie1000" wrote:

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?
--
PT

treat text as blank
 

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)



Reggie1000 wrote:

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?
--
PT

--

Dave Peterson