I have an Excel file having keys and values. The values contain
How can I remove these asterisks when for them Find and Replace does not work?
I am using Excel 2010.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
* is often a wildcard. To find a literal
* it is necessary to escape the character, for Excel you use
For example, to search for
*, you would use
Same as if you were searching for
?, you would use
So to answer your question and search for
**, you would use