title: Extract Subdirectory from a URL in Excel
body: <p>I'd like to do the following in Excel:</p>
  
  <blockquote>
    <p><a href="http://subdomain.domain/subdirectory/url.php" rel="nofollow">http://subdomain.domain/subdirectory/url.php</a> --> subdomain.domain/subdirectory</p>
  </blockquote>
  
  <p>subdirectory or any text after / and before the next /</p>
  
  <p>I already searched for formulas or add ins online but can't seem to find any formula for this. I only found a formula for subdomain.domain and url location.</p>
  
  <p>I'm currently trying to modify this formula, but I just can't figure out how!:</p>
  
  <blockquote>
    <p>MID(A1,FIND("/",A1,8),LEN(A1)+1-FIND("/",A1,8))</p>
  </blockquote>
  
  <p>Any help will be highly appreciated.</p>