Convert a URL into its title using the SPLIT function

The website you provided is protected, which prevents web scrapes from accessing its content. This is due to various security measures, such as CAPTCHAs and IP blocking, which are designed to avoid unauthorized data extraction.

One alternative/possible solution that can be provided is to extract the address directly from the link. This extracted address can then be formatted as 720b Waverley Road Dartmouth Dartmouth.

Sample Sheet Data:

Sample Code:

  function titleFromURL(url) {
  const urlModif = url.split('/').pop().replaceAll("-", " ").replace(/\b(\w)/g, f => f.toUpperCase());
  console.log(urlModif);
  return urlModif;
}

After saving the code back to your sheet, then type this in column B:

=titleFromURL(A1)

Sample Output:

Reference: SPLIT function