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?