How to create increment number inside text on L.O. Calc sheet

[fladramon]

hi, i want to do the “thing” that I drag the down-right symbol and numbers are being increasing

So we have this: www.example.com/1/lalala
and I want to make multiple links but with the number 1 going like 1,2,3,4,5…

Result: www.example.com/1/lalala
www.example.com/2/lalala
www.example.com/3/lalala
.
.
.
Or how i can add 3 cells into 1 so i can split the link into 3 cells

thanks in advance

[librebel]

Hello @fladramon,

In the first cell put the formula =HYPERLINK("www.example.com/" & ROW() & "/lalala"; "www.example.com/" & ROW() & "/lalala"), then drag the thingy downwards.

HTH, lib

[jimk]

The thingy is called a “fill handle” at Automatically Calculating Series - LibreOffice Help.

[fladramon]

Oh my… it worked!
**Thank you so much librebel **, I wouldnt and couldn’t think this formula

[librebel]

You’re welcome @fladramon :D, i’m always glad if i could be of help.

With Regards, lib

[jimk]

@fladramon: This should be a comment on the question, not an answer. See guidelines for asking. Still, this was a good enough question that I upvoted it.