copy a hyperlink and paste its url

Question

I have a cell containing an hyperlink to an external website.

Let's assume that the cell text is "microsoft" and the hyperlink is www.microsoft.com

I have the need to copy the cell and paste in another one in order to see www.microsoft.com

as a text.

Can I do that?

Thanks in advance for the help

oliverscheurich · Answer

giopio&nbsp;=TEXT(D10,0)Maybe you can use the TEXT function.&nbsp;

giopio · Answer

thanks OliverScheurich&nbsp;for the answer.That won't work because it returns "microsoft" instead of www.microsoft.com&nbsp;that is what I need

hansvogelaar · Answer

giopio&nbsp;
With the text "microsoft" in A2, enter the formula =HYPERLINK("https://www."&amp;A2&amp;".com") in B2

Forum Discussion