I am trying to find and replace the * (star, or shift+8) character in a bunch of formulas in Excel 2007. * of course matches the ENTIRE contents of the cell, which is not what I want. How do I disable this behavior?

2 Answers 2


Find and Replace (CTRL + H)

Search for ~*

Replace with whatever.


  • +1 Hit Ctrl-H, Put ~* in the Find field and + in the replace, and it changed the formula. Very nice.
    – rajah9
    Aug 5, 2011 at 18:48
  • @Zach, glad to help.
    – rlemon
    Aug 5, 2011 at 19:01
  • @iDevlop Sorry for the delay-- I thought I up voted an accepted yesterday, but I guess I forgot the second part!
    – Zach
    Aug 6, 2011 at 16:07

If you are doing this in code, you can look for CHAR(42), which is the numeric code for the * symbol.

Depending on how you do it, you should even be able to use the CHAR(42) in a worksheet formula.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.