if anyone could i would greatly appreciate it,

Write a sample of what the cells have and what do you expect to obtain.
Your questions should be consise but not always so short.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"(E-Mail Removed)" wrote:

> if anyone could i would greatly appreciate it,
>

ok here is what the excel file should look like

3 3 33 3 333 = should equal to 8 3's no matter if there is three
3's in a single cell

hope that helps


On Apr 4, 12:46*pm, Michael <Mich...@discussions.microsoft.com> wrote:
> Write a sample of what the cells have and what do you expect to obtain.
> Your questions should be consise but not always so short.
> --
> If this posting was helpful, please click on the Yes button.
> Regards,
>
> Michael Arch.
>
>
>
> "jzamil...@yahoo.com" wrote:
> > if anyone could i would greatly appreciate it,- Hide quoted text -
>
> - Show quoted text -

Try:

=SUM(LEN(A1:E1))-SUM(LEN(SUBSTITUTE(A1:E1,3,"")))

which is an array formula to be entered with Ctrl + Shift + Enter not just
enter.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


<(E-Mail Removed)> wrote in message
news:d7ff89c3-8706-403c-b89e-(E-Mail Removed)...
ok here is what the excel file should look like

3 3 33 3 333 = should equal to 8 3's no matter if there is three
3's in a single cell

hope that helps


On Apr 4, 12:46 pm, Michael <Mich...@discussions.microsoft.com> wrote:
> Write a sample of what the cells have and what do you expect to obtain.
> Your questions should be consise but not always so short.
> --
> If this posting was helpful, please click on the Yes button.
> Regards,
>
> Michael Arch.
>
>
>
> "jzamil...@yahoo.com" wrote:
> > if anyone could i would greatly appreciate it,- Hide quoted text -
>
> - Show quoted text -

that helped. thnx so much for ur help


On Apr 4, 2:04*pm, "Sandy Mann" <sandyma...@mailinator.com> wrote:
> Try:
>
> =SUM(LEN(A1:E1))-SUM(LEN(SUBSTITUTE(A1:E1,3,"")))
>
> which is an array formula to be entered with Ctrl + Shift + Enter not just
> enter.
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> sandyma...@mailinator.com
> Replace @mailinator.com with @tiscali.co.uk
>
> <jzamil...@yahoo.com> wrote in message
>
> news:d7ff89c3-8706-403c-b89e-(E-Mail Removed)...
> ok here is what the excel file should look like
>
> 3 *3 *33 *3 *333 *= should equal to 8 3's no matter if there is three
> 3's in a single cell
>
> hope that helps
>
> On Apr 4, 12:46 pm, Michael <Mich...@discussions.microsoft.com> wrote:
>
>
>
> > Write a sample of what the cells have and what do you expect to obtain.
> > Your questions should be consise but not always so short.
> > --
> > If this posting was helpful, please click on the Yes button.
> > Regards,
>
> > Michael Arch.
>
> > "jzamil...@yahoo.com" wrote:
> > > if anyone could i would greatly appreciate it,- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Glad that it helped. Thanks for the feedback

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


<(E-Mail Removed)> wrote in message
news:f1b6fa9c-fb0e-472f-9953-(E-Mail Removed)...
that helped. thnx so much for ur help


On Apr 4, 2:04 pm, "Sandy Mann" <sandyma...@mailinator.com> wrote:
> Try:
>
> =SUM(LEN(A1:E1))-SUM(LEN(SUBSTITUTE(A1:E1,3,"")))
>
> which is an array formula to be entered with Ctrl + Shift + Enter not just
> enter.
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> sandyma...@mailinator.com
> Replace @mailinator.com with @tiscali.co.uk
>
> <jzamil...@yahoo.com> wrote in message
>
> news:d7ff89c3-8706-403c-b89e-(E-Mail Removed)...
> ok here is what the excel file should look like
>
> 3 3 33 3 333 = should equal to 8 3's no matter if there is three
> 3's in a single cell
>
> hope that helps
>
> On Apr 4, 12:46 pm, Michael <Mich...@discussions.microsoft.com> wrote:
>
>
>
> > Write a sample of what the cells have and what do you expect to obtain.
> > Your questions should be consise but not always so short.
> > --
> > If this posting was helpful, please click on the Yes button.
> > Regards,
>
> > Michael Arch.
>
> > "jzamil...@yahoo.com" wrote:
> > > if anyone could i would greatly appreciate it,- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -