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
Jim
Thanks for helping me solve my problem
Jim
bigjim1216 , you are welcome