| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 :-) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing one part of an address | Excel Worksheet Functions | |||
| Parsing part of an address | Excel Discussion (Misc queries) | |||
| use the result of match function as a part of row address | New Users to Excel | |||
| search spreadsheet for 'xyz' as part of any hyperlink address | Excel Discussion (Misc queries) | |||
| VLOOKUP with cell address as part of the argument | Excel Discussion (Misc queries) | |||
Linear Mode
