Tuesday, 19 June 2018
  2 Replies
  7.6K 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.