Builtvisible

Builtvisible is an award-winning digital marketing agency driving forward the boundaries of SEO, content and analytics. With industry accreditation, direct access to your consultants and a 95% client retention rate, you are in safe hands.

London, United Kingdom
Founded: 2009
Staff: 40
More

Skills

Search Engine Marketing
Copywriting
Content Marketing
SEO
Digital PR
content strategy
Web Design & Build
Digital Marketing Consultancy
Technical SEO
Clients
The Telegraph
Towergate Insurance
Bravissimo
Charlotte Tilbury
Icelandair
lastminute.com
Rentokil
Sage
Shop Direct
TÜV SÜD

and 5 more

Sector Experience

Legal
Retail
Travel
Finance
Hospitality
B2B Services
Less

The Builtvisible cheatsheet of excel formulas for SEOs

7 February 2020 14:43pm

In this blog post we outline 15 ready-to-use Excel formulas that make manipulating cell content, whether it is text or number, easier and faster.

And to kick-off 2020 properly, we have a little gift to share with the SEO community and everyone else interested: a Googlesheet that regroups formulas, processes and shortcuts that we, SEOs, use heavily to process data faster.

15 Excel formulas covered include:

  • Extract anything before or after the 1st occurrence of a character
  • Extract anything before or after the 2nd occurrence of a character
  • Extract anything after the second to last occurrence of a character
  • Extract anything before or after the 3rd occurrence of a character
  • Extract a piece of text located in the middle of a string
  • Extract text between the 2nd and 3rd occurrence of a character
  • Extract anything after the last instance of a character
  • Remove duplicates from one or multiple columns and return ONLY a unique list of values in a specific column
  • Count the number of characters (not words!) in a cell
  • Count the number of words (not characters!) in a cell
  • See if a cell contains *any* question words
  • Classify your values (e.g. “Low”, “Medium” and “High”)
  • Count the number of keywords displayed in a row which are mapped to a page
  • Return the first non-blank cell in a row
  • Fix non-blank cells that appear as blank cells

Hopefully these formulas are useful to you and help you process your data in a much faster, clearer and easier way. You can also find all formulas from this post and my previous one on a Googlesheet available here, something that was requested from multiple readers.

And of course, if you use any formulas that are more advanced or better composed, please let me know in the comments. I’d love to hear them!

Tags

ExCeL
SEO