Remove Domain from a URL in Excel
excel
Solution
I tried this with the http and https versions of your URL (where A3 has your URL); seems to work.
=RIGHT(A3,LEN(A3)-FIND("/",A3,FIND("//",A3)+2))
Problem
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: https://www.walsallhealthcare.nhs.uk/contact-us/useful-links/subject-categories.aspx --> contact-us/useful-links/subject-categories.aspx 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? =MID(A1,FIND("/",A1,8),LEN(A1)+1-FIND("/",A1,8)) Also, I want to remove the "/" at the beginning. Is this possible? Thank you so much!