How to Leave Truly Empty Cell if Criteria for IF statement is FALSE

[silverbluemoon]

I need to know how to leave a cell truly empty if the criteria of my IF statements is untrue. Currently, I'll write something like:

=IF($A2="H","Happy Days","")

But for some reason, when I copy and paste the resulting range of values elsewhere (to rid myself of the formula that determined them), the cells that did not return a value (where the statement is FALSE), are not recognized by a "Go To Special > Blanks" request, until I select all of the "empty cells" and clear them manually. Yet when I try to do a search on the same range for an empty space, I get no hits. Any help is appreciated.


Thank you!

 

[RoryA]

You're better off having the formula return some text that you can use a Find and Replace on after pasting values. Otherwise you will never have a truly blank cell.