Find & replace in one column

P

Pete

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?
 
M

Mike

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
 
P

Pete_UK

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
 
G

Gord Dibben

Pete

Pre-select just column A then Edit>Replace>Options>Seach "by columns"

replace what: R2700
replace with: R2500

Replace all.


Gord Dibben MS Excel MVP
 
P

Pete

Thank you Gents - very helpful.

Pete


Gord Dibben said:
Pete

Pre-select just column A then Edit>Replace>Options>Seach "by columns"

replace what: R2700
replace with: R2500

Replace all.


Gord Dibben MS Excel MVP
Click to expand...
 
Top