Prev: Advanced Data Filter
Next: Imperial Weights in Excel
From: fabio on 29 Apr 2010 05:44
Hi

I am trying to manipulate some data strings and I want to count how many
times the characters '(' and ')' occur in each of the data strings on my
spreadsheet. I have tried some simple options but am unable to achieve the
result I want.

I would be very grateful if anyone is able to provide me with a method of
doing this.

Thanks
From: Jacob Skaria on 29 Apr 2010 05:54
To count from a data string which is in cell A1 use the below

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

To count all in a spreadsheet use the Find Dialog box and enter "(" and hit
FindAll which will list all the occurences and give a count at the bottom.
Make sure you select the option appropriately to avoid looking at
formulas....(If thats is your requirement)

--
Jacob (MVP - Excel)


"fabio" wrote:

> Hi
>
> I am trying to manipulate some data strings and I want to count how many
> times the characters '(' and ')' occur in each of the data strings on my
> spreadsheet. I have tried some simple options but am unable to achieve the
> result I want.
>
> I would be very grateful if anyone is able to provide me with a method of
> doing this.
>
> Thanks
From: fabio on 29 Apr 2010 06:01
Thank you Jacob. That worked fine as I did want it on a cell by cell basis.

"Jacob Skaria" wrote:

> To count from a data string which is in cell A1 use the below
>
> =LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(A1,"(",),")",))
>
> To count all in a spreadsheet use the Find Dialog box and enter "(" and hit
> FindAll which will list all the occurences and give a count at the bottom.
> Make sure you select the option appropriately to avoid looking at
> formulas....(If thats is your requirement)
>
> --
> Jacob (MVP - Excel)
>
>
> "fabio" wrote:
>
> > Hi
> >
> > I am trying to manipulate some data strings and I want to count how many
> > times the characters '(' and ')' occur in each of the data strings on my
> > spreadsheet. I have tried some simple options but am unable to achieve the
> > result I want.
> >
> > I would be very grateful if anyone is able to provide me with a method of
> > doing this.
> >
> > Thanks
 | 
Pages: 1
Prev: Advanced Data Filter
Next: Imperial Weights in Excel