View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

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