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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .