File Exchange Excel formula help please

[cordeliaflyte]

Any Excel wizzes want to help me with what should be a simple formula? I had a go at it and it was preposterously complicated in a way I can't imagine is right. (But maybe?). I'm just trying to generate the URLs for my photos, which are named sequentially, in an automated way. Here's the end result I'm looking for:

https://www.hostname.com/00001.jpg | https://www.hostname.com/00002.jpg 

So I need a formula that does
STRING + INCREMENTING NUMBER + STRING +INCREMENTING NUMBER + STRING

And then does the same in the next cell, picking up with the second number. (Or, incrementing each number by 2s — one odds and one evens). 

I figured out how to deal with strings and concatenation, but couldn't find a simple solution for incrementing without relying on Vlookup type stuff, which seemed silly. 

Thanks for any pointers in the right direction!

[shipscript]

@cordeliaflyte 

I'm not an Excel wizard, but with a little poking around on the web, I was able to come up with this solution.

You will need two columns, one to increment your base numbers and another to create the concatenated URL strings.

        A        B
1  Increment    PicURL
2          1    (see formula below)
3      =A2+2	

Formula for PicURL column:

="https://pinpointed.s3.us-east-2.amazonaws.com/"&TEXT(A2,"00000")&".jpg|https://pinpointed.s3.us-east-2.amazonaws.com/"&TEXT(A2+1,"00000")&".jpg"

DragCopy the formulas down all the rows.

The "TEXT" formula converts the number to a zero-padded text string.

[cordeliaflyte]

That is BRILLIANT! Thank you so much.