Need a simple formula for this...

hi,
i've a tidious job to search and replace a number which has got 1000 row entries in ms excel.i'm able to search of a number starting with 4460304 and while replacing i have to change that to 4460305,in next seach i have to replace the same 4460304 with 4460306 and evrytime while replacing it should get incremented.So for this repetitive process can any help with a seach and replace formula and where to write that formula and how to use that formula in ms excel...??i'm really need your help.

thanks in advance,
Sri

If you data is in A2 down try using this formula in an unused column, row 2 copied down

=IF(A2=4460304,COUNTIF(A$2:A2,4460304)+A2,A2)

That will increment each instance of 4460304 but leave other data unchanged. If you want to replace the original column with the new one you can Copy the new column then use Edit > Paste Special > Values to convert to values and then copy over the original.

I'd advise you to save the original first so that you can undo any changes if necessary