How To: Extract hyperlink contents in Excel for Mac

I found this information explaing how to extract links from excel data and wanted to pass it along:

You have a series of hyperlinks from which you want to extract the URLs. You want to keep the hyperlink display text as well.

  1. Copy the hyperlinks into a column in Excel (column A).
  2. Copy the hyperlinks into the adjacent column as well (column B).
  3. Select column B and right-click on the selected cells. Choose “Edit Hyperlink”
  4. In “Display” the value will be “multiple cells”. Delete this text and save. Just the URLs will remain in column B.
  5. Select column A and right-click on the selected cells. Choose “Remove Hyperlink”. Just the display text will remain in column A.

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply