Forum Discussion

Coco5335's avatar
Coco5335
Copper Contributor
Feb 07, 2020

Copying just hyperlink

I have pasted the names of domains with a hyperlink to each domain name. How can I copy and paste the hyperlinks into the cells next to them at mass?

Excel on Mac

3 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Feb 07, 2020

    Hello Coco5335,

     

    I'm not completely sure I understand what you're asking. However, if you have the urls located in column A and the name of the respective domains in column B, then a formula in column C could be:

    =HYPERLINK(A1,B1)

    Of course, copy down as necessary. 

  • Charla74's avatar
    Charla74
    Iron Contributor
    Feb 07, 2020
    Maybe separate the domain name and hyperlink with a comma then after pasting to Excel, use the text to columns function, using the comma as the delimiter.
    • Charla74's avatar
      Charla74
      Iron Contributor
      Feb 07, 2020
      (You can also add the comma en-masse, after pasting into Excel - select the range with data, hit CTRL + H for find / replace, in the find box enter http and in the replace box type ,http)

Resources