up vote -1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
25% accept rate
feedback

1 Answer

up vote 3 down vote accepted

Strings are handled the same as any data type. Just get a solid plus sign on the bottom right corner, and drag it down as general.
enter image description here enter image description here

You can also fill series
enter image description here

link|improve this answer
My apologizes, I acutally needed this url "mysite.com/mp3/file01.mp3"; where the "file01" portion requires update. – ray247 Feb 14 at 16:54
1  
Just do it my way and then concatenate the results `=concatenate(A1&".mp3")' and drag that – Raystafarian Feb 14 at 16:59
Thanks Raystafarian for your help and effort. I upvoted and marked you as answer. – ray247 Feb 14 at 17:54
I wish there was an easier way, but I don't know of one, nor can I find one. Maybe someone else will chime in – Raystafarian Feb 14 at 17:56
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.