Incrementing Part of an Address

[Phil]

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

 

[Roger Govier]

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

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