Forum Discussion

bigjim1216's avatar
bigjim1216
Copper Contributor
Jan 17, 2022
Solved

Formula for deleting the contents of a cell

Is there a function that I can use to clear the contents of a cell?  I'm using a formula in cell "c2"  if(a2="","",b2).  Simple formula but the problem I have is if this statement returns a blank cel...
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 17, 2022

    bigjim1216 

    As a comment. Excel sorts in such order

    (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ ` { | } ~ + < = > 0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

    after that logical TRUE/FALSE, after them errors and blanks are always on the last place.

    Since formulas in Excel can't return blank as a value, as workaround you may generate error as Patrice Brel  suggested or text like "zzz". Using conditional formatting you may hide them from showing.

alannavarro's avatar
alannavarro
Iron Contributor
Jan 17, 2022
Hello,

You can add a filter formula.

=(FILTER(C2:C10,C2:C10<>""))

And you could include also the sort formula to have the array sorted.
=SORT(FILTER(C2:C10,C2:C10<>""))


  • bigjim1216's avatar
    bigjim1216
    Copper Contributor
    Jan 17, 2022
    I couldn't get the filter idea to work. I haven't used this before so it was probably just my ignorance. But I really appreciate your help. I'm spending time now trying to learn more about filters because of your suggestion so it will really help me expand my knowledge.

    Thanks again

    Jim

Resources