View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mark
 
Posts: n/a
Default count of tab characters in a single cell

Thanks... exactly what I was looking for.

Of coure, now that you've told me that, I'm finding that there might be more
problems with the file than I thought, but hey... that's what I need to know!

Thanks.

"Gary''s Student" wrote:

Looking at A9:

=LEN(A9)-LEN(SUBSTITUTE(A9,CHAR(9),""))

will display the number of tab characters