Find & replace

[Guy Wates]

Hi

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

Guy

[EdMac]

Hi Guy,

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

HTH

Ed

[Gary''s Student]

Select the range of cells you want to change prior to running find/replace.
--
Gary''s Student


"Guy Wates" wrote:

>
> Hi
>
> I have excel 2003 and I want to replace certain characters within a
> selected range of cells. Excel will find, say 5 matching cells and then
> I select replace all with a different character. Then excel decides to
> change every matching character within the sheet. Can anybody help me
> to stop this happening.
>
> Guy
>
>
> --
> Guy Wates
>
>
> ------------------------------------------------------------------------
> Guy Wates's Profile: http://www.excelforum.com/member.php...fo&userid=2931
> View this thread: http://www.excelforum.com/showthread...hreadid=506689
>
>

[Guy Wates]

Hi Guy,

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

HTH

Ed

I have done that. It finds within the range but then replaces all found 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" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> I have excel 2003 and I want to replace certain characters within a
> selected range of cells. Excel will find, say 5 matching cells and then
> I select replace all with a different character. Then excel decides to
> change every matching character within the sheet. Can anybody help me
> to stop this happening.
>
> Guy
>
>
> --
> Guy Wates
>
>
> ------------------------------------------------------------------------
> Guy Wates's Profile:
> http://www.excelforum.com/member.php...fo&userid=2931
> View this thread: http://www.excelforum.com/showthread...hreadid=506689
>

[Guy Wates]

Thanks for your help