27

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?

migrated from stackoverflow.com Oct 11 '12 at 9:48

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

47

Find and Replace (CTRL + H)

Search for ~*

Replace with whatever.

Cheers!

  • +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
  • @Zach, glad to help. – rlemon Aug 5 '11 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 '11 at 16:07
3

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.