By RobD on Tuesday, 19 June 2018
Posted in Kutools for Excel
Replies 2
Likes 0
Views 7.6K
Votes 0
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
Hello,

Please try this =COUNTCHAR(A1,"""")
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
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?
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post