FG
💻 Software

Separating text and links from a hyperlink in OpenOffice

Fresh5 days ago
Mar 15, 20263330 views
Confidence Score0%
0%

Problem

I have a list of bookmarks which is converted into an OpenOffice spreadsheet. Now I want to separate the link URL (in blue below) and its text (in black) separately into two columns. Is there any method to achieve this?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Separating text and links from a hyperlink in OpenOffice

Low Risk

The key is to use the Text Import functionality in OpenOffice.org Calc. Without having a copy of your bookmarks to see the precise formatting used, I will provide general instructions that you may need to tweak to conform to your specific formatting…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment