Find and Replace

Can "find and replace" be executed for a selected range rather than the whole sheet or workbook.

Yes. I'd have gone crazy a long time ago if it didn't work that.

Just make sure you select more than one cell.

I tried as you said. At first it did not work. Then I played with the "Within" drop down. When I set it to sheet instead of Workbook it actually replaced only in cell section.

Thanks for the tip.