Increasing a number inside of a URL string

Hi,

I need to make a URl list in excel for every page in a thread.

The url string looks like this:

http://www.forum.com/subforum/12345-...-thread-1.html


the 1 right before the .html is the page number, and it is the only variable that changes. I need to find out how to increase that number by one each line so I get:


http://www.forum.com/subforum/12345-...-thread-1.html
http://www.forum.com/subforum/12345-...-thread-2.html
http://www.forum.com/subforum/12345-...-thread-3.html
...
http://www.forum.com/subforum/12345-...thread-10.html
http://www.forum.com/subforum/12345-...thread-11.html


and so on.

Is there an easy way to do this?