Delete part of a formula

D

dee

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!
 
D

Duke Carey

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
 
G

Gord Dibben

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
 
D

Dave Peterson

Search help for "wildcard characters".

From xl2003's help:

Wildcard characters
The following wildcard characters can be used as comparison criteria for
filters, and when searching and replacing content.

Use To find
? (question mark) Any single character
For example, sm?th finds "smith" and "smyth"
* (asterisk) Any number of characters
For example, *east finds "Northeast" and "Southeast"
~ (tilde) followed by ?, *, or ~
A question mark, asterisk, or tilde
For example, fy91~? finds "fy91?"
 
Top