Counting Within a Cell

's Computer Specifications

Hi,

How do I count the number of digits within a cell.

4,5,6,7

The answer should be four. I don't want to count the commas.

Thanks,

Tom G

's Computer Specifications

Hi Tom

Something like this will work:

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

Best regards

Richard

Tom G wrote:
> Hi,
>
> How do I count the number of digits within a cell.
>
> 4,5,6,7
>
> The answer should be four. I don't want to count the commas.
>
> Thanks,
>
> Tom G

's Computer Specifications

On 18 Dec 2006 01:05:15 -0800, "RichardSchollar"
<(E-Mail Removed)> wrote:

>Hi Tom
>
>Something like this will work:
>
>=LEN(SUBSTITUTE(A1,",",""))
>
>Best regards
>
>Richard
>
>
>Tom G wrote:
>> Hi,
>>
>> How do I count the number of digits within a cell.
>>
>> 4,5,6,7
>>
>> The answer should be four. I don't want to count the commas.
>>
>> Thanks,
>>
>> Tom G

Thanks, did the trick.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting the changes in a cell	NM	Microsoft Excel Worksheet Functions	9	10th Nov 2008 09:21 PM
Counting within a cell	cellcounting	Microsoft Excel Misc	4	27th Oct 2008 08:33 PM
COUNTING CELL	Rudy	Microsoft Access Getting Started	1	5th Apr 2008 09:24 AM
Counting within a cell	=?Utf-8?B?SmFuZQ==?=	Microsoft Excel Worksheet Functions	2	31st Mar 2005 01:29 AM
Counting cell values based on adjacent cell value over multiple columns	h2oskier	Microsoft Excel Worksheet Functions	3	19th Feb 2004 05:29 PM