Excel search for ~* or ~? sequence
~
is a special character, so it need to be skipped too.
Type ~~~*
to look for ~*
Type ~~~?
to look for ~?
Related videos on Youtube
Tim Staniford
Qualified mathematician and statistician. In a passionate but open relationship with numbers and analysis. Equally in love with the written word, my words or others'. Equally in love with people and the experiences that they bring. Currently working in as a Business Planning Analyst for UK Power Networks, London. I regard life as a thing to be explored. Today I feel like I'm having a great time doing that. I don't always feel that way. I'm human. Australian.
Updated on September 18, 2022Comments
-
Tim Staniford over 1 year
A previous question (link below) concerns how to search for the star and question mark characters in Excel. This can be done by entering ~* or ~? in the 'Find What' field. My question, then, is how does one search for the string ~* or ~? ?