Remove Hyperlinks function in Hyperlinks

If e.g. a cell has the function =+HYPERLINK("http://www.excelforum.com";"Excel Forum"), I want to copy this cell to an other cell which has only the name "Excel Forum", which act as usaully, that means click on the name will move you to that hyperlink.

I did a lot of reading for a solution by means of Google and found only one, the same as I found allready myself:
- Copy the original cell and paste it in a Word document. There you find the hyperlink form as I want. Then copy this hyperlink back to Excell and ready.

But that must be possible without using Word as immediate. But How?

Kind reagrds

Jan Lichtenbelt

I want cell A1, with the formula =+Hyperlink(), to be converted into the form like C1 (as said a form equal as met in e.g. Word documents).
Remark: Cell C1 is a real hyperlink, while cell A1 is not recognised is hyperlink using VBA.

The question still is how can I convert A1 into C1 in the worksheet or VBA?

Kind regards

Jan Lichtenbelt

Testhyperlinks.xlsm

Can someone help me with this problem?

There SHOULD BE a solution!

Kind regards

Jan Lichtenbelt

Dear boopathiraja

The formula Text() give just only the text and not the hyperlink as should be.

Thanks for help.

Kind regards

Jan Lichtenbelt

I believe the question is this: how to convert a formula-based hyperlink into an "inserted" hyperlink? That's going to be a VBA solution.

VBA or not-VBA, what will be a solution?

Kind regards

Jan Lichtenbelt

Dear All,

The solution to copy an cell to an new hyperlink cell, has been found
http://www.vbforums.com/showthread.p...ormat-RESOLVED

Dim h as Hyperlink

For each h in SourceRange

MyWorkSheet.Hyperlinks.Add TargetRange, h.Address

Next h



With kind regards

Jan Lichtenbelt