PDA

View Full Version : Replacing text in the formula in one part of a worksheet



mbbx5va2
06-27-2015, 08:21 AM
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? :think:

Thanks

SamT
06-27-2015, 08:00 PM
Select A1:A10, then Ctrl+H