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.
 

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

Back
Top