When doing redirects, for a new site –
sometimes, when you crawl the old/current site you will find a few rogue URLs that start with http: not https: and don’t end with a backslash.
If you’re doing a find and replace job, to create the destination URLs, this can mess with your final URLs.
Search “http:” to ensure, that if applicable, all the final URLs use the correct http protocol
Then use the formula below, to check the all end with a backslash
=IF(RIGHT(A1,1)=”/”,TRUE,FALSE)