Thread: count of tab characters in a single cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mark
 
Posts: n/a
Default count of tab characters in a single cell
Thanks... I've never used the substitute function was the problem (why I
didn't think of it).. but this will work great.



"Bernard Liengme" wrote:

=LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(9),""))
best wishes
--
Reply With QuoteReply With Quote