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?