Incrementing Part of an Address

  • Thread starter Thread starter Phil
  • Start date Start date
Hi Phil

Place your first entry in cell A5, then enter the following formula in cell
A6 and copy down as far as required
=LEFT(A5,66)&TEXT(ROW(),"0000")&RIGHT(A5,3)

--
Regards
Roger Govier

Phil said:
Sorry about the title, I wasn't sure how to phrase my question...

I'd like to increment a number which is part of a URL, for example

<img src=
"http://www.example.com/?module=images&func=display&fileId=0005"/>

I want to be able to copy the URL but increase the numeric part of the
address to 0006, 0007, 0008 etc.

Many thanks :-)

__________ Information from ESET Smart Security, version of virus
signature database 4741 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4741 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top