View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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