Hello
I am trying to achieve the following.
In A column, i have texts with links on it. I d like to separate them and put the url in the b column. Any idea how to do it ? Any simple formula ?
Thanks for your help
Edit your question and share a few samples (or one if the pattern is the same). Before pasting the samples there choose preformated text (Ctrl+E).
Maybe you can use menu Data - Text to Columns.
In 2020, the same question was asked and a user posted a Calc macro to:
- “GetURLs” from a cell.
- Output the actual link.
See:
If that doesn’t work, I linked to quite a few more methods last year in:
No. Calc only has a way to go from:
- text → clickable links.
It does not have a way to go from:
- URLs → text.