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.3e+01k times
33
Marcus Mangelsdorf
- 1,207
- 2
- 12
- 19
Zach
- 495
- 2
- 5
- 8
2 Answers
60
Find and Replace (CTRL + H)
Search for ~*
Replace with whatever.
Cheers!
rlemon
- 657
- 1
- 9
- 20
-
+1 Hit Ctrl-H, Put `~*` in the Find field and `+` in the replace, and it changed the formula. Very nice. – rajah9 Aug 05 '11 at 18:48
-
@Zach, glad to help. – rlemon Aug 05 '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 06 '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.
GSTD
- 295
- 3
- 8