allbestnet.com
- Extract all links on a page: "//@href";
- Extract all internal links on a page: "//a[contains(@href, 'domain.com')]/@href";
- Extract all external links on a page: "//a[not(contains(@href, 'domain.com'))]/@href";
- Extract meta description: "//meta[@name='description']/@content";
- Extract H1: "//h1";
- Extract email address(es) from page: "//a[contains(@href, 'mailTo:') or contains(@href, 'mailto:')]/@href";
- Extract social profiles (i.e. LinkedIn, Facebook, Twitter):"//a[contains(@href, 'linkedin.com/in') or contains(@href, 'twitter.com/') or contains(@href, 'facebook.com/')]/@href";
- Extract lastBuildDate (from RSS feed): "//lastBuildDate"
=LEFT(F12,(FIND(" (",F12,1)-1))
Find text before " (" in cell F12
Find text before " (" in cell F12
=COUNTIF(L$2:L,L2)
Count nr. duplicate in table L
Count nr. duplicate in table L
To help navigate the COVID-19 situation, ALLBESTNET.COM is sharing resources and tools to help and inform.
Copyright © 2020
Copyright © 2020