Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Oct 11 '12 at 9:48

This question came from our site for professional and enthusiast programmers.

up vote 30 down vote accepted

Find and Replace (CTRL + H)

Search for ~*

Replace with whatever.


share|improve this answer
+1 Hit Ctrl-H, Put ~* in the Find field and + in the replace, and it changed the formula. Very nice. – rajah9 Aug 5 '11 at 18:48
Works like a charm. Thank you! – Zach Aug 5 '11 at 19:00
@Zach, glad to help. – rlemon Aug 5 '11 at 19:01
if it works like a charm, accept the answer !!! – iDevlop Aug 5 '11 at 19:18
@iDevlop Sorry for the delay-- I thought I up voted an accepted yesterday, but I guess I forgot the second part! – Zach Aug 6 '11 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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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