Incrementing Part of an Address
 

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 :-)

Incrementing Part of an Address
 

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" wrote in message
...
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




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

The message was checked by ESET Smart Security.

http://www.eset.com