View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default count if cell if fill with text

=COUNTA(A1:A25)

Regards

Trevor


"
wrote in message ...
if a cell is fill up with text it is consider one count. what is the
formula
to use?