If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting Characters In A String
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 |
#2
|
|||
|
|||
Counting Characters In A String
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 |
#3
|
|||
|
|||
Counting Characters In A String
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 |
Thread Tools | |
Display Modes | |
|
|