• search and replace *


    I have a spread sheet with asterisks in a few cells. How can I use find and replace? Everytime I try to use the find and replace I believe it interprets my typing the asterisk as a wildcard. I tried “*” and it does not work. I also tried *** and ** and they do not work either.

    Viewing 0 reply threads
    • #510046

      If you put a tilde (~) before the asterisk, then Excel will find the actual asterisk character rather than using a wildcard search (the same applies to question marks)
      Hope that helps.

    Viewing 0 reply threads
    Reply To: search and replace *

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: