Nou

Folosind COUNTCHAR pe ghilimele

  Kutools pentru Excel
RobD
  RobD
  Marți, 19 iunie 2018
  2 Răspunsuri
  7.9K vizite
0
Voturi
Anula
Bună băieți,

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?

Noroc,
Jefui
0
Cele mai vechi primele  
qiuhongkun
qiuhongkun
de ani în urmă 5
·
#1638
0
Voturi
Anula
Buna,

Please try this =COUNTCHAR(A1,"""")
RobD
RobD
de ani în urmă 5
·
#1639
0
Voturi
Anula
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?
  • Pagina:
  • 1
Nu există răspunsuri făcute pentru acest post.