View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jouni Kananen Jouni Kananen is offline
external usenet poster
 
Posts: 2
Default How do I count rows within a cell?

Hi,

I need to count the number of rows within one cell. Values have been input
using Alt+Enter to cut the data on separate rows.

If if helps, I could also count how often ".h" appears in the cell because
the data are C header files...

I'd like to use something built in. I can write a macro of my own if that's
the only option.

BTW, is there a max number of rows a cell can take in?

Thanks in advance,
Jouni