Can you delete all asterisks in a sheet?
in [General]
|
From: JLatham on 12 May 2010 17:10 Hey, mine worked in my special case (just * entered into a few cells). Oh well.... "Gord Dibben" wrote: > Congrats. > > You are the only responder who got it right<g> > > > Gord > > On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student > <GarysStudent(a)discussions.microsoft.com> wrote: > > >Use Find/Replace > > > >Find > >~* > > > >Replace with nothing > > . >
From: Dave Peterson on 12 May 2010 17:45 And yours did get rid of all the asterisks, too. It may have done a bit more <vbg>, too! JLatham wrote: > Hey, mine worked in my special case (just * entered into a few cells). Oh > well.... > > "Gord Dibben" wrote: > > >>Congrats. >> >>You are the only responder who got it right<g> >> >> >>Gord >> >>On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student >><GarysStudent(a)discussions.microsoft.com> wrote: >> >> >>>Use Find/Replace >>> >>>Find >>>~* >>> >>>Replace with nothing >> >>. >> -- Dave Peterson
From: JLatham on 13 May 2010 21:38
yeah, I realized that once I saw Gord's posting. Goes to show you that given bad test data, even the worst solution may APPEAR to work great. "Dave Peterson" wrote: > And yours did get rid of all the asterisks, too. It may have done a bit more > <vbg>, too! > > JLatham wrote: > > > Hey, mine worked in my special case (just * entered into a few cells). Oh > > well.... > > > > "Gord Dibben" wrote: > > > > > >>Congrats. > >> > >>You are the only responder who got it right<g> > >> > >> > >>Gord > >> > >>On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student > >><GarysStudent(a)discussions.microsoft.com> wrote: > >> > >> > >>>Use Find/Replace > >>> > >>>Find > >>>~* > >>> > >>>Replace with nothing > >> > >>. > >> > > -- > > Dave Peterson > . > |