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?
How to Find and Replace the Character ‘*’ in Excel
find and replacemicrosoft excel
Best Answer
Find and Replace (
CTRL + H
)Search for
~*
Replace with whatever.
Cheers!