Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace on just One Column | Excel Discussion (Misc queries) | |||
Find and Replace in a column | New Users to Excel | |||
How to find/replace data in column | Excel Discussion (Misc queries) | |||
How to find/replace data in column | New Users to Excel | |||
is it possible to Restrict Find & Replace to 1 column | New Users to Excel |