How to convert column of hyperlinks to urls in excel

[Dharunya_Devi (Dharunya Balakrishnan)]

Hi Team,

I have a column of hyperlinks in excel which has 5000 rows.
I need to know how to convert all the hyperlinks to website URL’s at a time.

Regards,
Dharunya

[lrtetala (Lakshman Reddy)]

Hi @Dharunya_Devi

Can you try the below

Hyperlinks To URLs.txt (547 Bytes)

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@Dharunya_Devi

I have a column of hyperlinks in excel which has 5000 rows.
I need to know how to convert all the hyperlinks to website URL’s at a time.

@Dharunya_Devi

Assign activity:

Variable: row(websiteURL )

Value:
New Uri(row("YourHyperlinkColumnName").ToString()).ToString()