copy a hyperlink and paste its url

[giopio]

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

[#2]

@giopio 

=TEXT(D10,0)

Maybe you can use the TEXT function. 

[#3]

thanks @OliverScheurich for the answer.

That won't work because it returns "microsoft" instead of www.microsoft.com that is what I need

[#4]

@giopio 

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