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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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

Help>Answer Wizard "wildcard"

Shows some info including use of the tilde.


Gord

On Wed, 27 Apr 2005 15:45:51 -0700, dee <[email protected]> wrote:

>Thanks so much to both of you! Is this in the help anywhere?
>
>It worked like a charm!