This is a case of semantics between the words blank and empty.

F5SpecialBlanks really means F5SpecialEMPTY CELLS

A cell that contains a formula blank is not an empty cell. A formula blank
is an empty TEXT string. If you convert that to a constant by using
CopyPaste SpecialValues the cell *still contains the empty text string* so
the cell *is not empty*.

--
Biff
Microsoft Excel MVP


"jhnnyboy247" wrote in message
...
I am having an issue where i have used a formula such as
=if(C2=1,"True",""),
if ill down an entire column, then I copy and paste the data in that
column
as values. If i then try to use Go To.., Special, Blanks, these empty
fields
(that the above formula would have put as "") are not selected.

This has worked this way in every edition of excel that i have used.
Why does excel not consider these as "blank" fields when they show nothing
in the cell and nothing in the formula bar?