Get Website URL

Posts: 26
Joined: Fri Nov 16, 2018 7:37 am

Get Website URL

Postby Bilo » Thu Sep 05, 2019 6:15 am


I have a table with in column A, the names of the websites and in column B, the titles of the subjects.
I would like to have in column C, the URL link that allows me to directly reach the subject on the Web,
I have more than 1000 lines in my file and I can't do this manually

Do I have to start working again from the beginning with Power query, Power BI or VBA?

Do you have a solution to automatically create these links?

Thank you in advance for your support

Have a good evening
(10.72 KiB) Downloaded 52 times

Posts: 1
Joined: Mon Apr 20, 2020 11:32 pm

Re: Get Website URL

Postby LoneExcel » Mon Apr 20, 2020 11:34 pm

Use this formula in C2 and copy it down the column:

=HYPERLINK(""&SUBSTITUTE(A2,"https://","")&"+"&SUBSTITUTE(B2," ","+"),B2)

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests