How to blank "blank cell"?

netwsam

New member
Joined
Jan 14, 2015
Messages
4
Reaction score
0
Points
0
I am running a program called Aspen, which return a set of data in a column with numbers or blank.
Say, Column A1 to A10 are numbers, except A9- which appeared to be a Blank.

When I use the ISblank function on A9, it returned as not a blank or zero.

When I try to use Max (A1 to A10) or Avg (A1 to A10), I have got an error in return.

How can I make the return cell from Aspen as a truly blank?
 
Maybe try

=LEN(SUBSTITUTE(A9," ",""))=0
 
Thanks Bob for the tip
The aspen at different date may return a random blank between A1to A9
Could I make an if statement
If any cell return with a blank then substitute this cell to be a true blank. When you am average or max, that blank cell will be ignored
Thanks
 
Hi netwsam, how about:-
Code:
=IFERROR(--A1,"")
 
Back
Top