16 March, 2012 #SEO

Excel Tip – Trim URL’s to just Domain (Root)

If you use OSE or some other tool (majestic, link diagnosis) for back link analysis then you probably have issues with listing information concisely.

I typically work off a few columns:

  • URL
  • Title
  • Anchor
  • DA

The problem is many of the URL’s are deep links with long strings. So to trim a url column down to just show the root domain use the following in Excel:

=LEFT(A1,SEARCH(“/”,A1,8))

What this does is search cell A1 for all instances of the / character and trim back to the last one after the 8th character (because http:// is 8 characters and you want the one after this).

Enjoy!

0 Comments on Excel Tip – Trim URL’s to just Domain (Root)

Leave a Comment

Your email address will not be published. Required fields are marked *

You Might Be Interested In

Share via
Copy link
Powered by Social Snap