formula to choose a hyperlink from a cell

G

Guest

I have a cell which contain a hyperlink.
Now I want a formular to pick the hyperlink in this cell.(result is a text)
Example:
cell A1: "Music" (it was formated as blue and underline by Excel) and
have a hyperlink: "C:/my music/music.html"
Now I want cell A2 have text "C:/my music/music.html" (use a formula to do it)

Sorry for my English
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
Cell interpreted as mailto 5
Conditional format cell containing hyperlink 2
Hyperlink text from linked workbook 1
Hyperlink to cell within a sheet breaks when cells are sorted 1
Hyperlink formula with destination in same worksheet 1
How will hyperlink cell reference update after copy paste? 4
HYPERLINK() Help 1

Top