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?
Asked
Active
Viewed 1.4e+01k times
33
Marcus Mangelsdorf
- 1,277
Zach
- 495
2 Answers
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.
GSTD
- 295
~*in the Find field and+in the replace, and it changed the formula. Very nice. – rajah9 Aug 05 '11 at 18:48