Ask Your Question
1

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

asked 2017-12-25 11:57:36 +0200

fladramon gravatar image

updated 2017-12-25 13:05:55 +0200

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2017-12-25 14:58:21 +0200

librebel gravatar image

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

edit flag offensive delete link more

Comments

The thingy is called a "fill handle" at https://help.libreoffice.org/Calc/Aut....

Jim K gravatar imageJim K ( 2017-12-26 21:25:21 +0200 )edit
0

answered 2017-12-25 17:59:42 +0200

fladramon gravatar image

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

edit flag offensive delete link more

Comments

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

With Regards, lib

librebel gravatar imagelibrebel ( 2017-12-26 00:53:49 +0200 )edit

@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.

Jim K gravatar imageJim K ( 2017-12-26 21:21:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-25 11:57:36 +0200

Seen: 434 times

Last updated: Dec 25 '17