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" <AlexWilson@discussions.microsoft.com> wrote in message
news:5BF0D29A-B21E-4F90-97BF-7CA13398332A@microsoft.com...
> 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 Wilson@discussions.microsoft.com> wrote in message
>> news:B4E6F013-3E3C-460A-8D29-C8A69DE2A444@microsoft.com...
>> > 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?
>> >
>>
>>
>>