Separate text from URL in Excel column

Question

What I have is a column in Excel with a list of URLs like this:

• first link
• second link
• ...

What I would like is to separate the "text" from the "URL" like this:

• first link | http://www.example.com/1
• second link | http://www.example.com/2
• ...

I'm using LibreOffice, but I'd accept and answer also for Google Spreadsheet or even a python script.

Answer 1

Three steps simple solution (for Google Sheets):

• just copy and 'paste values only' to get the text (or use concatenate-with-nothing)

• check this answer for a custom function to get the url

• concatenate text and url.