text with sum function

  • Thread starter Thread starter VC
  • Start date Start date
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??
 
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.
 
Back
Top