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
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