How to Remove Protocol and Trailing Slash from URL in Excel - Office 365

Sometimes you may need to remove the protocol and trailing slash from URL and save the URLs that way in Excel worksheet. You can use MID, FIND, LEN and RIGHT functions to remove the protocol and trailing slash from the URL.