[Solved] Increase value in one cell based on another cell

[Mike0]

Hi, so I have the following text that I would like to increment based on a formula:

Code: Select all

https://img2.vod.com/image/large/100/100001.large.jpg

I would like to increment it like this:

Code: Select all

ttps://img2.vod.com/image/large/100/100001.large.jpg
ttps://img2.vod.com/image/large/100/100002.large.jpg

....

ttps://img2.vod.com/image/large/100/100999.large.jpg

ttps://img2.vod.com/image/large/101/101000.large.jpg
ttps://img2.vod.com/image/large/101/101001.large.jpg

So every thousand times, the number that started at 100, increases by one, so a few numbers would be : 101/101000 , 105/105675 , 107/107889 ,

The last six numbers increment by one, but the number after the word /large/ increments by one every thousand.

I would need it in the range from 100/100000 to 199/199999.

Edit: Due to the NSFW nature of the images, I've disabled live links. [robleyd, moderator]

How could this be done in Calc, and leaving the other text intact ?

The photos are DVD covers, I do not mean to offend anyone, they are adult films. Im just collecting the covers to have on my PC.

Thank you for help.

[RusselB]

Most of the links you provided are missing the initial h of the https website address, thus making the links return blank pages.
That said, I suspect that it would be more beneficial if you uploaded a sample of your spreadsheet rather than pictures, as that way we can see and (try to) work with the layout you are currently using.

[Mike0]

Thank you for your answer.

The spreadsheet would go:

Code: Select all

https://img2.vod.com/image/large/100/100001.large.jpg
https://img2.vod.com/image/large/100/100002.large.jpg
.
.
.
https://img2.vod.com/image/large/101/101001.large.jpg

So the three numbers after the word /large/ are like a chapter number, they would need to go up by 1 for every 1000 photos.

Code: Select all

https://img2.vod.com/image/large/102/102000.large.jpg

I would need it to be written in lines in a spreadsheet starting with

Code: Select all

https://img2.vod.com/image/large/100/100001.large.jpg

and ending with

Code: Select all

https://img2.vod.com/image/large/199/199999.large.jpg

Im sorry I cant upload the spreadsheet because I havent made one, because I dont know how to increase the numbers using Calc.

Thank you for any help. Or if it can be done using Notepad++ or some other program ?

Edit: Due to the NSFW nature of the images, I've disabled live links. [robleyd, moderator]

[FJCC]

Does the attached file do what you want? I put values in the first 100 rows, then near rows 1000, 2000, 100,000.

[Zizi64]

And - if you want working hyperlinks in your spreadsheet file - you can use the function HYPERLINK().

[Mike0]

Does the attached file do what you want? I put values in the first 100 rows, then near rows 1000, 2000, 100,000.

Yes, thank you, it does what I needed

Now I can have a collection of DVD covers

Thank you all for help.

I would only have one more question. Is it possible to define a cell copy range. So that I dont have to do it with a mouse and pull down for a long time, but with a formula ?

[FJCC]

I will use the layout of the file I posted as an example. Imagine you have entered the formulas in C1:E1 and now you want to paste them down to row 100000. Select C1:E1 and press CTRL + C to copy that range. You will now see a small box at the left edge of the window on the formula bar (usually that is the region just above the column headers) that displays C1:E1. Edit that to C2:E100000 and press enter. The range C2:E100000 will become highlighted. Press CTRL + V to paste the copied formulas. It may take a few seconds to fill such a large range.

[Mike0]

Thank you, thats what I was trying to do. I knew it could be done elegantly Good thing we have computers and software to make work with large data sets easier