Note: The other languages of the website are Google-translated. Back to English
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
  0.9K 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!