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:
I am able to add whatever character I like to exclude in this part
However, it is not accepting a double quotation mark
" in any order. How to add
" in this
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.