Forum Discussion
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...
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 Zafter 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.
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 Zafter 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.
- I was able to do a work around using your suggestion with the zzz and then after the sort, getting rid of them. works good. I really appreciate the help. All of the answers helped. I had not worked with the trim suggestion or filters before, so now I'm working on learning that.
Thanks for helping me solve my problem
Jimbigjim1216 , you are welcome
