Counting Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TrentA - 19 Oct 2007 01:04 GMT

I have the following formula in a cell

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

This is for counting data such as:

1,2,3,4

If I just want to count the numbers (and not the commas) it works
fine. But I would like to drag this down and count an entire column
but in some of the cells I have data such as:

1,2*,3,4,5**,6,7*,8

Again I just want to count the numbers, not the commas or the
asteriks.

Thanks

Reply to this Message

JE McGimpsey - 19 Oct 2007 01:11 GMT

one way:

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

> I have the following formula in a cell
>
[quoted text clipped - 14 lines]
>
> Thanks

Reply to this Message

TrentA - 19 Oct 2007 02:16 GMT

Thank you

>one way:
>
[quoted text clipped - 18 lines]
>>
>> Thanks

Reply to this Message

RagDyer - 19 Oct 2007 01:34 GMT

What return would you expect from:

10,20**,30*,40
?

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>I have the following formula in a cell
>
[quoted text clipped - 14 lines]
>
> Thanks

Reply to this Message