6

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.

0

2 Answers 2

16

Asterisk * 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 ~*~*.

From: Find or replace text and numbers on a worksheet

4
  • 1
    @random: Could you please confirm why my edit was reversed? As per THIS I was advised to ensure that I posted more than just a mere link... Dec 6, 2013 at 9:34
  • A whole page as an image means you still don't have any actual content to "read". It's all trapped in an image. The "no links as answer alone" means you need to include at least an applicable portion of the source/website/link on how it answers the problem, not just a link to read more.
    – random
    Dec 6, 2013 at 16:36
  • Comparing the two original versions of both answers, this one leaves out what the OP should type in, until another user edited in the actual answer. Again, do not screenshot a whole webpage and paste that as an answer. You cannot search text in images and you should always reframe answers instead of just copy-paste. Adding a link shows where you got the information from if you referenced it elsewhere
    – random
    Dec 6, 2013 at 16:51
  • If you would like to ask the community what they think of taking a screenshot of a webpage and saying that's an answer, do feel free to ask on meta.superuser.com
    – random
    Dec 6, 2013 at 16:53
7

Try replacing ~*~*. Single * characters are interpreted as wildcards, as are ? characters. The ~ before it 'escapes' these special characters.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy