Replacing text in the formula in one part of a worksheet

[mbbx5va2]

Hi

If you want to replace text in the formula in all cells in a worksheet one simply uses ctrl + H however what if we wanted this to be applied to say data in cells: A1:A10 only?

Any ideas?

Thanks

[SamT]

Select A1:A10, then Ctrl+H