After you convert to values, you can see that those "empty" cells aren't really
empty.

Tools|Options|Transition tab|check Transition navigation keys
(remember to toggle it off later!)

Now look at the formula bar for one of those empty cells--you'll see a single
quote.

I usually use a formula like:

=if(a1=0,"ok",na())

convert to values and then do that Edit|replace on the #n/a! string.

(Kind of the same response as the deletethis message, huh?)

cwinters wrote:

Yes but... I forgot to mention a key step I do. After running this IF
formula I always copy and paste special the cells as values. So the
formulas no longer exist. The "" is turned into nothingness that is
not, truly, nothingness. The Find technique is great if you want to
find and replace something within a given cell, but I want to find and
merely TAG something (in an adjacent cell; hence using the formula)

--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=393270

--

Dave Peterson