Excel 2007 : Find and Replace

[HangMan]

Is there any way do do a 'Find and Replace' on a single cell, rather that a complete sheet? For Example, I have a very long formula in a cell and I would like to find '167' in just tha selected cell and replace it with '168', but there are many other '167's on the sheet!

[Paul]

Hi HangMan,

Simply select that cell and put 167 in the 'Find what' box and 168 in the 'Replace with' box. Click Replace, then close that window. Don't click 'Replace All'.

[HangMan]

Hi Paul,

Okay, now I feel stupid... many thanks, that's what I needed!