Ask Your Question
0

Inserting multiple hyperlinks in a column

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

AndreiP gravatar image

Hi,

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

Comments

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
0

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

pierre-yves samyn gravatar image

Hi

  1. You can insert in col. C this formula: =HYPERLINK("www.url.com/"&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

Regards

edit flag offensive delete link more

Comments

This is working great, thanks! Furthermore, in Writter I'm able to remove www.url.com/ 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

Stats

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

Seen: 393 times

Last updated: Sep 30 '16