Thread: Counting number of time a character appears in a string
View Single Post
  #6   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default Counting number of time a character appears in a string
On Thu, 20 Oct 2005 14:25:02 -0700, Henrik
wrote:

Does anyone know a way to automatically count how many times a certain
character counts in a text string?

To count the number of appearances of a character in a text string:

=LEN(A1)-LEN(SUBSTITUTE(A1,char_to_count,""))


--ron
Reply With QuoteReply With Quote