Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

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

share|improve this answer
    
My apologizes, I acutally needed this url "mysite.com/mp3/file01.mp3"; where the "file01" portion requires update. –  ray247 Feb 14 '12 at 16:54
1  
Just do it my way and then concatenate the results `=concatenate(A1&".mp3")' and drag that –  Raystafarian Feb 14 '12 at 16:59
    
Thanks Raystafarian for your help and effort. I upvoted and marked you as answer. –  ray247 Feb 14 '12 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 '12 at 17:56

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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