Remove Domain from a URL in Excel

[lumineers01]

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!

 

[FDibbins]

Could you provide a few samples of the URL's you are working with? (both versions please?)
Im thinking that a len()-len(substitute()) might be what you need

 

[taurean]

Does this work:

=MID(A1,FIND("|",SUBSTITUTE(A1,"/","|",3),1)+1,199)

 

[lumineers01]

Does this work:

=MID(A1,FIND("|",SUBSTITUTE(A1,"/","|",3),1)+1,199)

Thanks! Working smoothly! Thank you so much!

 

[lumineers01]

Could you provide a few samples of the URL's you are working with? (both versions please?)
Im thinking that a len()-len(substitute()) might be what you need

The other formula is working! But thank you also!