View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heliocracy Heliocracy is offline
external usenet poster
 
Posts: 29
Default Ignoring Cells with Only Spaces

I'm trying to use the COUNTA function, but I need it to ignore cells that
contain ONLY spaces. I don't want to ignore cells that merely begin or end
with a space, and I don't know how many spaces may be present in the cells I
do want to ignore. Can anyone please help?

Thanks,
Heliocracy