Need a simple formula for this...will you help me in 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

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.