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

Patrice Brel

Copper Contributor

Jan 17, 2022

Good morning, you probably could use the NA() ( showing #N/A ) to replace ""
=IF(A2="",NA(),B2)
Regards

bigjim1216

Copper Contributor

Jan 17, 2022

I couldn't get the NA() to work but along with Sergei Baklan's reply it got me going the right way and I'm pretty sure I found a solution.

Thanks for your help. I really appreciate it. I have another issue I'd like to learn about, but I'll put it into another post.

Thanks again,
Jim

Forum Discussion

Formula for deleting the contents of a cell

Resources