In the Find text box use a tilde before the asterisk
~*.07
Excel may have converted your .07 to a 0.07, so be sure you put the correct
characters into the Find box
"dee" wrote:
Hi,
I posted this earlier, but it didn't seem to appear in the group.
In any case, I would like to delete only part of a formula throughout my
worksheet.
For example, *.07
The other part of the formula varies, so I can't use a standard Find and
Replace. If I type *.07 in the Find box and Replace with nothing, it removes
the entire formula.
Help!
Thanks!
--
Thanks!
Dee
|