Using Libreoffice Calc to create a link in a spreadsheet

English Applications
1

opensuse 42.3
libbreoffice 6.0.4

I have a spreadsheet with two columns: the name of a school COL-A, and its URL COL-B. I wish to combine the contents of the two columns into a third to create a link: <a href=“COL-B”>COL-A</a>.

What would be the expression to create that string?

2

Hi
Well a URL will automatically hyperlink?


=hyperlink(COL-B,COL-A)

A1="Some School"
B1="https://some-school.edu"
C1="=hyperlink(A1,B1)"
3

If you want the actual text then:

="<a href=’" & “”"" & B1 & “”"" & “>” & A1 & “</a>”

4

The proper order is “hyperlink(b1, a1)”; otherwise, just what I wanted.

Thank you!

5

What is the purpose of the third column? Why not just make column B the hyperlink? This is not a criticism, just a question of layout that I might be missing and be able to use on my own elsewhere.

6

Excellent. Thank you.

After working with the hyperlink() function, I realized that wasn’t quite what I wanted; it was the actual text of an URL that is desired. The above provides that.

7

The spreadsheet is generated by our CRM service. We are creating a report that will be re-formatted into a HTML table that is inserted into to our website to display the results. Part of the display is the company name is also a link to that company.