The easiest thing to do is use regex and the Search function
Remove text before a forward slash in Excel:
To remove text or URL paths after a slash, use find and replace then /*
To remove the slash after the domain use Find and Replace – Example.com/ and replace with “nothing”:
You can then concatenate the domain back in place at the end, if you need to
Also had this reply from Reddit
*I’ve never really got my head around URLs, URIs and URNs. I think the product-name that I’m after, is a URN.
https://myshop.com/category-folder/product-name