Counting the number of times a character occurs in a cell

's Computer Specifications

How can you count the number of times a character occurs in a single
cell ?

For example, A1 contains the text:

abc,def,ghi

If you were counting the number of times the comma character occurred
in A1, the correct answer is 2.

's Computer Specifications

Never mind.

I figured it out.

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

Exceluser

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting no. of times a character occurs in a cell	hsg	Microsoft Excel Worksheet Functions	3	24th Mar 2009 06:49 PM
Counting number of times a value occurs	da	Microsoft Excel Misc	4	9th Sep 2008 03:51 PM
Counting the number of times more than 1 variable occurs	chrisdedobb	Microsoft Excel Misc	5	3rd Jan 2006 06:20 PM
Counting the number of times a specific character appears in a cell	PCLIVE	Microsoft Excel Worksheet Functions	3	4th Nov 2005 05:08 AM
Counting the number of times a character appears in a cell	Gary Thomson	Microsoft Excel Worksheet Functions	1	23rd Feb 2004 05:33 PM