Find & replace

[Guy Wates]

Hi

I have excel 2003 and I want to replace certain characters within
selected range of cells. Excel will find, say 5 matching cells and the
I select replace all with a different character. Then excel decides t
change every matching character within the sheet. Can anybody help m
to stop this happening.

Gu

 

[EdMac]

Hi Guy,

Make sure you only select the range of cells that you want to chang
the characters in and then Excel will only find and replace within tha
range.

HTH

E

 

[Guest]

Select the range of cells you want to change prior to running find/replace.

 

[Guy Wates]

Hi Guy,

Make sure you only select the range of cells that you want to chang
the characters in and then Excel will only find and replace within tha
range.

HTH

Ed

I have done that. It finds within the range but then replaces all foun
within the sheet

 

[Herbert Seidenberg]

Don't hit Find All.
Find Next is OK.

 

[L. Howard Kittle]

Hi Guy,

Once you have selected the data:

Find > Find what > Replace Tab > Replace with (if anything) > Replace >
clicked as many times as needed to cycle through your selection.

HTH
Regards,
Howard

 

[Guy Wates]

Thanks for your hel