Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 19 June 2018
  2 Replies
  825 Visits
0
Votes
Undo
Hey guys,

Just got Kutools for Excel in order to speed up QA checks on a large number of software text strings.
One of them requires me to identify the number of quotation marks in each string for technical reasons. I was hoping to use the COUNTCHAR feature for this but it does not seem to accept the " character, and I cannot find a way to use an escape character either.

Any way to make this work?

Cheers,
Rob
3 years ago
·
#1638
0
Votes
Undo
Hello,

Please try this =COUNTCHAR(A1,"""")
3 years ago
·
#1639
0
Votes
Undo
Excellent, thanks for that! Works.

Just out if curiosity (if you have time) - what is the logic behind 4 quotation marks in this formula? I tried 3 in my original attempts but never got the idea of adding more. What is escaping what here?
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!