Replace text for selected cells only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hall - 16 Mar 2006 23:40 GMT

Is it possible to select specific cells and then have the Replace feature
only apply to those cells, particularly if I use the Replace-All button?

Reply to this Message

Dave Peterson - 17 Mar 2006 00:45 GMT

That's the way it works.

Are you experiencing something different?

(one tip. Don't hit the Find all button. If you notice, your selection is lost
when you do that.)

> Is it possible to select specific cells and then have the Replace feature
> only apply to those cells, particularly if I use the Replace-All button?

Signature

Dave Peterson

Reply to this Message

DJH - 17 Mar 2006 00:53 GMT

Selecting only one cell, and Excel will try to Replace throughout the whole
sheet.

Selecting multiple cells, and Excel will Replace only within the Selected
Cells.

> Is it possible to select specific cells and then have the Replace feature
> only apply to those cells, particularly if I use the Replace-All button?

Reply to this Message

Hall - 17 Mar 2006 02:46 GMT

Wow that was simple. I must've been doing it wrong.

Thanks!

> Selecting only one cell, and Excel will try to Replace throughout the
> whole sheet.
[quoted text clipped - 4 lines]
>> Is it possible to select specific cells and then have the Replace feature
>> only apply to those cells, particularly if I use the Replace-All button?

Reply to this Message