Allintitle search from Google Sheets

=REGEXREPLACE(importxml("http://www.google.com/search?as_occt=title&q="&CHAR(34)&A17&CHAR(34),"//div[@id='resultStats']"),".*?([0-9,]+) (w|r)esults?","$1")

CHAR(34) refers to a single quote.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s