1

With help of this Is there an Excel formula to identify special characters in a cell? VBA code and excel UDF, I am checking special characters in my csv file. Using this formula:

=RegExCheck([@ItemTitle],"[^\s,'.()!&%A-Za-z0-9é–_/©™®°¼½¾⅓⅔⅕⅖⅗⅘⅙⅚⅛⅜⅝⅞•-]")

I am able to add whatever character I like to exclude in this part

[^\s,'.()!&%A-Za-z0-9é–_/©™®°¼½¾⅓⅔⅕⅖⅗⅘⅙⅚⅛⅜⅝⅞•-]

However, it is not accepting a double quotation mark " in any order. How to add " in this

[^\s,'.()!&%A-Za-z0-9é–_/©™®°¼½¾⅓⅔⅕⅖⅗⅘⅙⅚⅛⅜⅝⅞•-]

exclusion group in excel UDF.

[^\s"A-Za-z0-9é_/©™®°¼½¾⅓⅔⅕⅖⅗⅘⅙⅚⅛⅜⅝⅞•-] with a double quote mark is working fine in https://regexr.com/ in starting positions but not working in excel 2019 (365) anywhere.

0

Here are some suggestions:

  • Use the character twice ("")
  • Use the Unicode encoding of the character : \u0022
  • Thank you. I confirm your both suggestions are working. – Junaid Nov 11 '18 at 19:25

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.