Exceljet

Quick, clean, and to the point

Remove trailing slash from url

Excel formula: Remove trailing slash from url
Generic formula 
=LEFT(url,LEN(B5)-(RIGHT(url)="/"))
Explanation 

To remove a trailing slash from a URL or path, you can use a formula based on the LEFT and LEN functions. In the example shown, the formula in cell C6 is:

=LEFT(B5,LEN(B5)-(RIGHT(B5)="/"))

How this formula works

At the core, this formula uses the LEFT function to return text starting from the left. To work out how many characters should be returned, the formula uses this expression:

LEN(B5)-(RIGHT(B5)="/")

Here, total characters are calculated with the LEN function. From this number, the result of the following expression is subtracted:

RIGHT(B5)="/"

With number of characters not specified, RIGHT will return the last character in the string. If this characters is a forward slash "/", the expression returns TRUE. If not, it returns FALSE.

Because TRUE and FALSE are coerced automatically to 1 and zero in math operations, we  subtract zero from the result of LEN when the last characters is not "/" and we subtract 1 when the last characters is "/".

The result is provided to LEFT, which returns the final result.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.