dee

Preface the Replace What with ~*0.07

The problem with *0.07 is that Excel views the 8 as a wildcard and replaces
everything.

The tilde ~ shows Excel you are looking for the literal *


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 11:50:06 -0700, 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!