Ask Your Question

Inserting multiple hyperlinks in a column

asked 2016-09-30 09:50:15 +0200

AndreiP gravatar image


Is there any quick way that I can insert a lot of hyperlinks In a column considering all links have the same address and only the last parameter after "/" differs?

Here's how I currently do it:

  1. Add formula in Column B
  2. Pasting values in Column C
  3. Individually clicking values in Column C and pressing space and it generates the link

image description

edit retag flag offensive close merge delete


How did you get the numbers in the # column ? If you manually wrote them or used cell copying, there's a much better way: write =ROW() - 1 to A2 and add it to each cell in the column. Now the number will always be correct no matter how you move your data, assuming the formula isn't changed.

rautamiekka gravatar imagerautamiekka ( 2016-09-30 16:28:03 +0200 )edit

I just numbered the 1st one and then double-clicked it and it numbered bellow, but thanks for the tip!

AndreiP gravatar imageAndreiP ( 2016-09-30 17:07:55 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-09-30 10:01:51 +0200

pierre-yves samyn gravatar image


  1. You can insert in col. C this formula: =HYPERLINK(""&B2)
  2. Or, if you need "real" links:
    • Copy col. C
    • Paste As Unformatted Text in Writer then ToolsAutoCorrectApply (FormatAutoCorrect in older versions)
    • Select, copy then paste in Calc


edit flag offensive delete link more


This is working great, thanks! Furthermore, in Writter I'm able to remove and keep just the ID as text but with the hyperlink I want.

AndreiP gravatar imageAndreiP ( 2016-09-30 17:06:55 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-30 09:50:15 +0200

Seen: 588 times

Last updated: Sep 30 '16