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

Unfortunately, a formula cannot return a true blank.
Simply because the cell contains a formula, it therefor is not blank.

I do however wish the copy/pastespecialvalues would result in that being a blank.
But sadly it does not.

You could try using NA() instead of ""
=IF($A2="H","Happy Days",NA())

Then after the copy/pastespecial you can do the Goto Special - constants - errors

Hi,

The above said if statement is fine, it will be helpful to identify the problem if u provide a workbook.

Punnam

Here's a nice method to get rid of the "" blanks after the copy/paste special..

Highlight the column
Data - Text To Columns
Deliminated - Next
UNcheck ALL options
Finish.