MS Excel / VBA help thread

You are reading a single comment by @NotThamesWater and its replies. Click here to read the full conversation.

•

NotThamesWater

In Libreoffice Calc, how do I return the hyperlink in a cell?

e.g. A1 has the value "foo", but is linked to "http://www.google.com" - How do I get cell B2 to show "http://www.google.com"

How doeds it work in excel?

•

aggi in reply to @NotThamesWater

I don't think there's an easy way to do it if they've been created using the Insert Hyperlink other than a macro.

If they've been created using a formula =HYPERLINK() then you can use =FORMULATEXT() to get the contents and trim it using search or similar.

About

Avatar for NotThamesWater @NotThamesWater started