Empty Cell not empty

[Phillip Topping]

If I use the following formula:

=IF(B25="","",B25+C25) in Column U all the way down
to Row 20000

to create a new value...

(Column B has a date and Column C has a Time) and then
copy and paste Column U to Column T as values, I see empty
cells in Column T once my data runs out (presently around
Row 40.

However....if I use the CountA function,it is telling me
that I have data in Column T all the way down to Row 20000.

Since this combined Date/Time is being used as X Axis data
it is screwing up the graph because Excel thinks those
cells are Jan 1, 1900 when in fact they are supposed to
be "nothing".

How can I change the original formula to prevent this or
how can I identify and find the character in Column T and
delete it.

I know I can easily just highlight the range and delete
it...but I need to put it in a macro as the number of data
points will vary over time.

TIA
Phillip

 

[Debra Dalgleish]

In the following thread, Dave Peterson suggests a couple of methods for
clearing the cells:

http://groups.google.com/groups?&[email protected]

 

[Tushar Mehta]

If your fake empty cells will appear only at the end of the data set,
you can use something like =COUNTA(A1:A8)-COUNTIF(A1:A8,"").

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions