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
|