tags:

views:

18

answers:

1
Q: 

Extract hyperlink from Open Office Calc Sheet

I have an Open Office Calc Sheet with a column full of data that has hyperlinks. I wish to trasnfer the hyperlinks to another column. How do I extract them?

Thanks.,.

A: 

It seems one must write a custom function for it.

Ali  2010-07-27 21:48:39

related questions

setting a:visited link to same state as a:link and a:hover
Would you recommend the book "Programming in Scala" for an experienced developer?
Adding Hyperlinks to created Bookmarks in a Word documnet using Ruby
Software that clicks e-mail links on page?
how can i check the start of the string in php ?
Changing the color of a selected link that is embedded in a table.
how can i use Hyperlink button in gridview ?
Where can I find easy to understand information about Unicode?
Hyperlinks In Sharepoint Webpart
Find CorelDraw Web links
Redirect to a link using the default broswser in Windows Form based application
asp.net hyperlnk control
Best practice: How to track outbound links?
Is it possible to set a style of link that shows only when the linked webpage is being viewed?
ASP.NET GridView CommandField Update/Cancel does not wrap
How To change the HREF for a Hyperlink using jQuery
CSS - Is there a way to get rid of the selection rectangle after clicking a link?
XML add <a> hyperlink
Insert a Link Using CSS
Windows .url links that point to same address when copied over or deleted
How can I set the text of a WPF Hyperlink via data binding?
How can I add an HyperLink in TRichEdit using Delphi
Find coordinates of every link in a page
Easiest way to convert a URL to a hyperlink in a C# string?
How should I handle autolinking in wiki page content?