Hello everyone
I want to Calculate the number of special characters
I want to have the overall results as spreadsheets attached below.
I do not know what formula to use, anyone knows please help me.
Note: do not use extra column to calculate
thank you!
Last edited by vutienhp; 01-27-2015 at 06:02 AM.
Please change the name of your thread. Think in terms of Google searches. Others may then benefit from any answer(s) that you get here.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Sorry, I do not know how to change the title like?Originally Posted by Glenn Kennedy
I want to replace the title is: Count the number of special characters
Someone can help my request in post # 1?
Thank you!
I completely forgot about you. Sorry...This solution doesn't like the ? symbols. Can you work around that limitation
Thank you!I completely forgot about you. Sorry...
Your formula is resolved partial results.
With the number plus the character "?" or "/" do not know how to do it?
I don't see any /s in your example. In the case of ?, in your example it was INSTEAD of a number, rather than WITH a number. Can they not simply be deleted?
Try it like this
=SUMPRODUCT((0+SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2:B11,"*",""),"?",0),"/","")))
Last edited by AlKey; 01-28-2015 at 12:25 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
OK!
It is true that in my example there is no "/".
I mean if instead
"10 *" = "/" or "?" What is the formula used?
Looking forward to getting advice from you.
Alkey, thanks. I think in straight lines and never think about nested substitute functions...
Great!Thank you very much!
Once again, apologies for forgetting about you!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks. It'd also be appreciated if you were to click the Add Reputation button at the foot of those who helped you reach a solution.
Last edited by Glenn Kennedy; 01-28-2015 at 01:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks