Results 1 to 5 of 5

Thread: How to blank "blank cell"?

  1. #1

    How to blank "blank cell"?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Maybe try

    =LEN(SUBSTITUTE(A9," ",""))=0

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

  4. #4
    Conjurer Beamer's Avatar
    Join Date
    Nov 2014
    Posts
    109
    Articles
    0
    Excel Version
    365
    Hi netwsam, how about:-
    Code:
    =IFERROR(--A1,"")

  5. #5
    Quote Originally Posted by Beamer View Post
    Hi netwsam, how about:-
    Quote Originally Posted by Beamer View Post
    Code:
    =IFERROR(--A1,"")
    Thanks guys, it works !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •