Find & replace in one column
 

Hi

I want to change the following part numbers in column 'A' using Find/Replace.

R2700 should now be R2500
B3200 should now be B3000

When I run it though it changes numbers in other columns which I dont want.

Any suggestions?
--
TIA
Pete
XP SP2, XL 2003

Find & replace in one column
 

IF you type in R2700 to find there should be no problem changing all
R2700 to R2500 an also this should not change anthing else

"Pete" wrote:

Hi

I want to change the following part numbers in column 'A' using Find/Replace.

R2700 should now be R2500
B3200 should now be B3000

When I run it though it changes numbers in other columns which I dont want.

Any suggestions?
--
TIA
Pete
XP SP2, XL 2003

Find & replace in one column
 

You should highlight column A first, by clicking on the letter A at
the top of the column. Then when you do CTRL-H (Find & Replace) it
will only operate on the highlighted range.

Hope this helps.

Pete

On May 2, 1:06 am, Pete wrote:
Hi

I want to change the following part numbers in column 'A' using Find/Replace.

R2700 should now be R2500
B3200 should now be B3000

When I run it though it changes numbers in other columns which I dont want.

Any suggestions?
--
TIA
Pete
XP SP2, XL 2003

Find & replace in one column
 

Pete

Pre-select just column A then EditReplaceOptionsSeach "by columns"

replace what: R2700
replace with: R2500

Replace all.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 17:06:01 -0700, Pete wrote:

Hi

I want to change the following part numbers in column 'A' using Find/Replace.

R2700 should now be R2500
B3200 should now be B3000

When I run it though it changes numbers in other columns which I dont want.

Any suggestions?

Find & replace in one column
 

Thank you Gents - very helpful.

Pete


"Gord Dibben" wrote:

Pete

Pre-select just column A then EditReplaceOptionsSeach "by columns"

replace what: R2700
replace with: R2500

Replace all.


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 17:06:01 -0700, Pete wrote:

Hi

I want to change the following part numbers in column 'A' using Find/Replace.

R2700 should now be R2500
B3200 should now be B3000

When I run it though it changes numbers in other columns which I dont want.

Any suggestions?