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!