text with sum function

V

VC

It may not be possible to even do this, but here goes...I
have a site link which links to specific photo stored at
an http address. It ends with a numbered JPG ie.
http://websitestorage.1052.JPG. Is there anyway to do a
formula so that the text stays the same, but the number
near the end goes up one each time??
 
N

none

VC,

This will create the text you want, but it is not
formated as a hyperlink.
In A1 put the firt part: http://websitestorage.
In B1 put the number to start at.
In B2 put the next number.
Then select B1 & B2 and drag down to fill as many cells
as you need.
In C1 put the last part: .JPG
In D1 put the formular =$A$1 &B1 & $C$1
Then you can copy and the paste the formular.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top