Forum Discussion
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...
thanks OliverScheurich for the answer.
That won't work because it returns "microsoft" instead of http://www.microsoft.com that is what I need
With the text "microsoft" in A2, enter the formula =HYPERLINK("https://www."&A2&".com") in B2