Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 19 June 2018
  2 Replies
  6.8K 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
5 years ago
·
#1638
0
Votes
Undo
Hello,

Please try this =COUNTCHAR(A1,"""")
5 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.