Forum Discussion

giopio's avatar
giopio
Copper Contributor
May 23, 2022

copy a hyperlink and paste its url

I have a cell containing an hyperlink to an external website.  Let's assume that the cell text is "microsoft" and the hyperlink is http://www.microsoft.com   I have the need to copy the cell and p...
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 23, 2022

giopio 

=TEXT(D10,0)

Maybe you can use the TEXT function. 

giopio's avatar
giopio
Copper Contributor
May 23, 2022

thanks OliverScheurich for the answer.

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

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 23, 2022

    giopio 

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