First, use a function such as
XPathOnUrl() to scrape the desired block of text from the page. Here's how you would get the 'first
<p> text' on SeoToolsForExcel's homepage:
=XPathOnUrl( "https://seotoolsforexcel.com/", "(//p/text())", , , "text")
RegexpFind() to get the first word or sentence.
First word (assuming above result is in A1):
=RegexpFind(A1, "(\w+)", 1)
or First sentence:
=RegexpFind(A1, "([^\.\?!]+)", 1)
Hope this helps!