Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Oct 11 '12 at 9:48

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

2 Answers 2

up vote 19 down vote accepted

Search and Replace

Search for ~*

Replace with whatever.

Cheers!

share|improve this answer
    
and by Search and Replace I of course mean CTRL + H Find and Replace –  rlemon Aug 5 '11 at 18:48
    
+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
3  
if it works like a charm, accept the answer !!! –  iDevlop Aug 5 '11 at 19:18

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

 
discard

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.