How to stop counting blank cells

[p86c]

So I have pasted data from generated from a piece of software into my excel sheet.

One of the formula returns a value for the number of cells in a column that has data in it.

Unfortunately it is counting all the cells in the column, including the blank ones - so I am guessing they have not transferred as blank.

I find that is I delete each blank cell manually then the count works again - but there are hundreds of these to do.

I think a find an dreplace might work - but what am I finding? and what am I replacing it with...just a blank?

And pointers?
p86c

 

[Fluff]

You could also try

Sub P86c()
   With ActiveSheet.UsedRange
      .Value = .Value
   End With
End Sub