How do I perfom a character count in a single cell in Excel?

's Computer Specifications

I need to peform a character count for certain cells in Excel. I found a
formula for counting words within a cell but not the number of specific
characters.

's Computer Specifications

If you count spaces as a character, you can use directly the function LEN.
If you don't want the spaces to count, use something like:
=LEN(SUBSTITUTE(A1," ",""))

Hope this helps,
Miguel.

"RonNette72791" wrote:

> I need to peform a character count for certain cells in Excel. I found a
> formula for counting words within a cell but not the number of specific
> characters.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I increase viewable cell character count limit in Excel?	Surfcaster	Microsoft Excel Misc	2	15th Dec 2009 11:32 PM
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ?		Microsoft Excel Programming	6	7th Oct 2009 12:28 PM
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ?		Microsoft Excel Worksheet Functions	7	7th Oct 2009 11:10 AM
Excel 2003, Linked Spreadsheet, Cell Character Count	Chuck Hague	Microsoft Excel Misc	3	7th Apr 2008 09:34 PM
I need to count occurr. of the character "," in a single cell	=?Utf-8?B?b3JjaGlkMTE2NTI=?=	Microsoft Excel Worksheet Functions	5	26th Mar 2007 06:27 PM