Excel and Sheet Formula

-

Google Sheet

Extract number from string and number

 =VALUE(REGEXREPLACE(G104,"[^[:digit:]]", ""))


Microsoft Excel

Xpath to get search result form google SERP
//*[@id="result-stats"]/text() search result
//*[@id="rso"] Full result

Comments

Post a Comment

Popular posts from this blog

On-Page SEO Checklist

-
Short  Title Intro H2 Video FAQ Share & Comment Related post Author Permalink Feature Image Meta tag Click to tweet For Site: Keyword research  - niche selection Brandable domain name Try to keep the domain name short as much as possible (in wp setup - remove last /). Brandable Logo Favicon   Apple Touch Icon Android Icon sitemap.xml robots.txt Navigation: Home, About (mission, vision, team), Contact, Jobs/Careers, Pricing, Service, Privacy policy, Affiliate Discloser (order doesn’t matter) Setup 301 page Setup 404 page Public who-is info Domain buy for a long time Frequent update information. Communication – comment section, send message, email, phone, live chat. Exit pop-up Search box Subscribe   Navigation (next, previous, page no … ) Social like/share buttons Link with SMM Boost site/page speed (use the Google PageSpeed Insights tool to figure out your site’s loading speed. Wordpress plugins WP Rocket and WP Smush It can help spee...
Read more

Social Share + Bookmarking Sites List

-
Social Share Facebook Twitter Google+ LinkedIn VK Pinterest Flickr Weheartit MySpace Tumblr Taringa Skyrock Tagged   [dead] Friendster Bookmarking Reddit Digg Flipboard Stumbleupon Pearltrees Plurk Bibsonomy Diigo Delicious Folkd Bizsugar Slashdot Scoop Fark Blogogate Need to Category https://dribbble.com/ https://del.icio.us/ https://getpocket.com/ http://digg.com/ http://www.folkd.com/page/social-search.html http://www.bizsugar.com/?utm_source=fuel&utm_medium=referral&utm_campaign=lrfuel https://slashdot.org/ https://weheartit.com/ https://www.scoop.it/ https://www.trendiee.com/internet/newsvine-shutting-number-one-alternative/ https://www.diigo.com/ https://www.bibsonomy.org/ http://www.citeulike.org/ https://www.pearltrees.com/ https://dzone.com/pages/about https://flipboard.com/ https://feedly.com/i/welcome https://www.instapaper.com/ http://kirtsy.com/ http://linkagogo.com/ https://list.ly/ http://www...
Read more

Guest Blogging Instructions

-
Select A Site For Guest Post Number of Trafic: 500+ blogging site Adsense, affiliate,  Any visitor if the site is not monetize blogging based site. Such as shop, service, product supply, product manufacture, job, studies/research, etc. Any visitor if site age less than 2 years. Trafic Country: Prefer:  English Country such as USA, UK, Canada, Australia.   Avoid:  Bangladesh, India, Philippines, Pakistan, China ... Checking tools:   ahrefs ,  ubersuggest ,  serpstat ,  semrush Example Site language: English Niche:  Must be related Avoiding niche  (very very important) Multi niche – basic design checking, good looking PBN,  No bad neighbor: By checking the inbound links, outgoing links, competitors Site growth: Positive growth of traffic and continuity Not huge t raffic drops History: Clean way-back history Low Percentage of Guest Posts: Site is not only for the guest post Social proof N...
Read more