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 speed things up. Lazy l
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.cra
Read more

Image Sharing Sites List

-
https://4shared.com/ https://mediafire.com/ http://filefactory.com/ https://drive.google.com/ https://box.com/ https://onedrive.live.com/ https://www.dropbox.com/ https://www.filedropper.com/ http://depositfiles.com/ https://zippyshare.com/ https://www.pearltrees.com/ http://wikiupload. https://www.facebook.com/ https://twitter.com/ https://plus.google.com/ https://www.linkedin.com/ https://vk.com/ https://www.tumblr.com/dashboard https://pinterest.com/ http://www.instagram.com/ https://flickr.com/ https://imgur.com/ https://myspace.com/ http://photobucket.com/ https://diigo.com/ https://archive.org/ http://fotolog.com/ http://tinypic.com/ https://500px.com/ https://morguefile.com/ https://weheartit.com/ https://public.fotki.com/ https://fancy.com/ http://myphoto.eu/ https://netdit.com/ https://reverbnation.com/ https://imageshack.us/ https://houzz.com/ https://imgur.com http://cheezburger.com http://tinypic.com https://fotolog.com http://ima
Read more