Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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 32 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

You must log in to answer this question.

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