Add hyperlink to a column

Learning Initatives Reboot Your Skills 2021
1

May I know if it is possible to add hyperlink(“https://www.google.com.hk/”+ColumnA’s value) to Column A. For example, in the upload excel, want to add A2 as https://www.google.com.hk/145, A3 as https://www.google.com.hk/234, the others are the same.

Thanks.

2

2

Hi @li.yu,

Xaml:
hyperlink.xaml (7.0 KB)
sample input&output:
hyperlink.xlsx (11.9 KB)

Thanks!

3

thanks, but want to have the hyperlink in A2, not in B2. the final result is link this.
2

4

Hi @li.yu,

Please check this workflow:
hyperlink.xaml (14.3 KB)

Macro file:
AddHyperLink_Macro.txt (311 Bytes)

Sample Output:

hyperlink.xlsx (12.8 KB)

Thanks!

5

Thanks, I already did it via write cell with hyerlink formular

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.