Inserting multiple hyperlinks in a column

[AndreiP]

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

[rautamiekka]

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.

[AndreiP]

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

[PYS]

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 Tools▸AutoCorrect▸Apply (Format▸AutoCorrect in older versions)
• Select, copy then paste in Calc

Regards

[AndreiP]

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.