Some non ascii codes are in my file. They are represented by ? (the question mark).
I need to find them and correct them. How do I search for the character "?" ?
Thanks.
Some non ascii codes are in my file. They are represented by ? (the question mark).
I need to find them and correct them. How do I search for the character "?" ?
Thanks.
See: https://superuser.com/questions/4586...-mark-in-excel
The ? is a wildcard which represents a single character, and the * is a wildcard character that represents any string of characters.
When searching for either wildcard character, Excel will simply find everything, whether or not these actual characters appear in the cells you're searching.
To find either of the specific characters, when not using them in a wildcard search, you must precede it in your search criteria with a tilde, the ~ character.
~? finds only the ? character
~* finds only the * character
? finds all single characters
* finds all strings of characters
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you so much. I tried wrapping it in "". Nothing worked.
This is much simpler.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks