Why copy Hyperlink individually when you have vba....

Extract hyperlink from cell

You can use a macro:

Open up a new workbook.

Get into VBA (Press Alt+F11)

Insert a new module (Insert > Module)

Copy and Paste the Excel user defined function below

Get out of VBA (Press Alt+Q)

Use this syntax for this custom Excel function: =GetURL(cell,[default_value])

Vba coding:

Function GetURL(cell As range, Optional default_value As Variant) 'Lists the Hyperlink Address for a Given Cell 'If cell does not contain a hyperlink, return default_value If (cell.range("A1").Hyperlinks.Count <> 1) Then GetURL = default_value Else GetURL = cell.range("A1").Hyperlinks(1).Address End If End Function

If you have any query or want any help related to excel feel free to join our Telegram channel and message us..

Channel link :

https://t.me/msexcelmaster101