I have a URL in "Column B" in the attached sheet. I require "Business Website URL"
in Column C (Company Website). Right now, I am doing it manually, opening the URL in "Column B", finding the business website URL and copy pasting the "Business Website URL" in Column C. Is there any automated way in Google sheets to copy the "Business Website URL". Attached an example sheet for reference
https://docs.google.com/spreadsheets/d/1uRplK6RisRycqR5fUQcLeHHDm8wpRf2mFEjDuo5SzlA/edit?usp=sharing
>Solution :
Type in C5:
=IMPORTXML(B5,"//a[@class='bxl w-button']/@href")
This formula visits the url specified in B5, and looks for a element with bxl w-button class, returning the href attribute.