Count of " in a specific cell
I would like to count the number of instances that a quote appears in a given cell. Most of the formulas I would use normally are add-ons in Excel that I don't have available on my work machine. Can somebody tell me the most effective ways to count the number of instances of a specific character in a cell in Excel 2013? I think VBA might be overkill but that also might be the only means to do it. If so, can somebody help me figure out how to do that? thanks.
Your profile says Excel 2016, but you mention 2013 - which is it?
Either way:
=COUNTIF(count_range,"character")
e.g. =COUNTIF(A1:A10,"a")
In your case, you would need this:
e.g. =COUNTIF(A1:A10,"""")
Sorry - I realise now that I misread your request.
Last edited by AliGW; 04-24-2019 at 12:58 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If you're counting the number of occurrences within a cell, try this:
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Try this instead:
=LEN(A2)-LEN(SUBSTITUTE(A2,"""",""))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks