Counting Within a Cell

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussions Access Excel InfoPath Outlook PowerPoint Publisher Word

Directory User Groups

Related Topics

Outlook Express Internet Explorer Windows MS Server Products More Topics ...

MS Office Forum / Excel / New Users / December 2006

Counting Within a Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom G - 18 Dec 2006 09:02 GMT

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

Reply to this Message

RichardSchollar - 18 Dec 2006 09:05 GMT

Hi Tom

Something like this will work:

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

Best regards

Richard

> Hi,
>
[quoted text clipped - 7 lines]
>
> Tom G

Reply to this Message

Tom G - 18 Dec 2006 09:14 GMT

>Hi Tom
>
[quoted text clipped - 17 lines]
>>
>> Tom G

Thanks, did the trick.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.