I have a link http://example.com/file01 and I would like to duplicate the link but with the "file01" part increment like "file02", "file03" etc. So I thought about Excel could do this on an integer cell as I drag the cell lower right hand corner downward. My question is that how do you do this with a string like in my case? Thanks!
Edit My apologizes, I acutally needed this url "http://example.com/mp3/file01.mp3" where the "file01" portion requires update.