Find and Replace function in Excel

R

Retep

Find and Replace function in Excel only works for data within Formulas not
Values within Cells
 
N

Nick Hodge

If you have a later version of Excel then select 'Options' from the dialog
and select values from the 'look-in' drop-down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top