lists & numbering

[rosstierney]

hey

i'm wondering if anyone can help with a formula for the following example:

i would like cell a1 to contain http://www.example.com/100.gif then http://www.example.com/101.gif to be entered into cell a2 automatically etc.

http://www.example.com/102.gif
http://www.example.com/103.gif
http://www.example.com/104.gif
http://www.example.com/105.gif

thanks in advance

ross

[Mikeopolo]

Try a custom format:

"http://www.example.com/"###0".gif"

Then enter 100, 101 in first two cells, then highlight these two, and fill down.

Regards
Mike

[NBVC]

Tryy:

=LEFT(A1,FIND(".com/",A1)+4)&TEXT(MID(A1,FIND(".com",A1)+5,3),"000")+1&RIGHT(A1,4)

copied down... where A1 house first entry

Edit:

If you want to retain Hyperlinks, then:

=HYPERLINK(LEFT(A1,FIND(".com/",A1)+4)&TEXT(MID(A1,FIND(".com",A1)+5,3),"000")+1&RIGHT(A1,4))

[oldchippy]

Hi,

Welcome to the forum, does this help?

[rosstierney]

amazing thanks guys especially oldchippy!