Thanks so much to both of you! Is this in the help anywhere?

It worked like a charm!
--
Thanks!

Dee


"Gord Dibben" wrote:

Typo alert

"views the 8 as" should read "views the * as"

Gord

On Tue, 26 Apr 2005 12:18:55 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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!