title: Remove Domain from a URL in Excel
body: <p>I'm dissecting urls for SEO purposes and I'm searched all forums for a formula that can remove the domain from a url, but can't seem to find the formula that returns favorable results. This is what I want to do:</p>
  
  <p><a href="https://www.walsallhealthcare.nhs.uk/contact-us/useful-links/subject-categories.aspx" rel="noreferrer">https://www.walsallhealthcare.nhs.uk/contact-us/useful-links/subject-categories.aspx</a> </p>
  
  <p>--> <strong>contact-us/useful-links/subject-categories.aspx</strong></p>
  
  <p>I'm using this formula in Excel to remove domain. However this doesn't work for secured sites, and I always have to replace "8" with "9" to make it work. Is there any way to make this work for both http and https websites?</p>
  
  <blockquote>
    <p>=MID(A1,FIND("/",A1,8),LEN(A1)+1-FIND("/",A1,8))</p>
  </blockquote>
  
  <p>Also, I want to remove the "/" at the beginning. Is this possible?</p>
  
  <p>Thank you so much!</p>