Delete part of a formula
 

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

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

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!

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!

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!

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?"


dee wrote:

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!



--

Dave Peterson

HelpAnswer Wizard "wildcard"

Shows some info including use of the tilde.


Gord

On Wed, 27 Apr 2005 15:45:51 -0700, dee wrote:

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

It worked like a charm!