Select those "blank" cells and hit Edit--Clear--All, then save the file.
Does that help the counta?
************
Anne Troy
www.OfficeArticles.com

"Alex Wilson" wrote in message
...
No I don't, the cells seem to have something in them, but when I click on
them there's nothing there, not even a " " (Space). All I'm after counting
is
weather they have text in them.

Thanks

"Anne Troy" wrote:

So do you want to count the unseen or not?
************
Anne Troy
www.OfficeArticles.com

"Alex Wilson" <Alex wrote in message
...
I'm trying to count then number of cells with data in them, however the
=countta and =countif don't seem to work as some of the cells are
filled
with
something unseen. They arn't filled with spaces, and the cells that I
am
counting have different text entries, so I can't use countif (text
entry).
Any suggestions?