Find & replace

G

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
 
E

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
 
G

Gary''s Student

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

Guy Wates

EdMac said:
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
Click to expand...

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

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
 
Top