Forum Discussion
Special Characters not found in 'Find & Select' nor with 'Advanced Filters'.
Hello, I was wondering if anyone has advice on how to solve a particular issue I am facing. I am doing text analysis in RStudio using an Excel dataset. RStudio is showing certain terms like "pdf\...
Find special characters in subsyntax in Excel.
According to the search results, there is no easy way to do this.
How to Find Special Characters in Excel (3 Easy Methods)
Format text or numbers as superscript or subscript
A possible solution is:
Convert the cells with subsyntax to regular text cells
Use the find and replace function or a formula like
=SUMPRODUCT(–ISNUMBER(SEARCH({"!","#","$","%","(",")","^","@ ","[","]","{","}"}, A2)))>0
to find special characters
Convert the cells back to subsyntax
I hope this helps you.