David
Tue Aug 23 12:03:14 CDT 2005
Hi Michael,
I have Excel 2000 and I don't get any indication before or after.
"Michael" <Michael@discussions.microsoft.com> wrote in message news:CA5795D6-4F19-431F-8ADE-24CF883B0F3A@microsoft.com...
> Thanks for response but, no, I want Replace All without "Find Entire cells
> only" checked. It should make the replacement, for cells selected, but
> should notify how many replacements are made (same behavior as Word). Right
> now, it IS replacing within the selection but it does not report (alert box)
> changes.
>
> "David McRitchie" wrote:
>
> > Hi Michael,
> > When you use Ctrl+H to make replacements and fill in the
> > from and to fields. Do you see buttons on the right for
> > Find next, Close, Replace, Replace All
> > sounds like you want to use the Find next, then the Replace for
> > each occurrence.
> >
> > Also be aware of the the box at the bottom to "Find Entire cells only"
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Michael" <Michael@discussions.microsoft.com> wrote in message news:222CA366-5FD3-4FA7-A2EA-FEF78077142A@microsoft.com...
> > > Historically, when I select cells and do a "replace all" (via Ctrl+H) Excel
> > > reports the number of replacements it is making (same as with Word). I have
> > > just started at a new location-office. Excel does not report this. It
> > > replaces without asking for confirmation. I cannot find settin or info that
> > > will cause it to report as discribed above.
> > >
> > > Help, please (solution, info, etc).
> >
> >
> >