View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default how can i change a sequence of numbers using find replace

"sumesh56" wrote:
how to change a sequence of numbers using

[....]
I have filled some columns in excel
numbers from 301 to 309. i want to change
these to 311 to 319. how can i accomplish
this task?


The devil is in the details, which I suspect you omitted.

If all the numbers were in contiguous cells in one column, there would be a
simple answer, to wit:

1. Put 10 into an unused cell, and copy it (ctrl+C).
2. Select the contiguous cells, right-click and click on Paste Special, Add,
OK.

However, I suspect the numbers are grouped into tables, as in
http://www.excelbanter.com/attachmen...tachmentid=953, which you
referenced in another recent question.

So you would have to repeat the process above for each group of columnar
data, table by table.

That might be just as well, because I suspect you do not want to add 10 to
all the numbers in all the tables. Instead, I wonder if you want to add a
different amount to the numbers in each table.