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
