Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel VLOOKUP Function
  • How to get first column number in range in Excel
  • Perform case-sensitive Lookup in Excel
  • How to use Excel MMULT Function

Data Analysis Examples

  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to calculate average last N values in a table in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • How To Remove Duplicates In Excel Column Or Row?

Data Validation Examples

  • How To Create Drop-down List in Excel
  • Excel Data validation require unique number
  • Excel Data validation date in next 30 days
  • Excel Data validation exists in list
  • Excel Data validation don’t exceed total

How to remove trailing slash from url in Excel

by

To remove a trailing slash from a URL or path, you can use a formula based on the LEFT and LEN functions.

Formula

=LEFT(url,LEN(B4)-(RIGHT(url)="/"))

Explanation

In the example shown, the formula in cell C6 is:

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

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(B4)-(RIGHT(B4)="/")

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

RIGHT(B4)="/"

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.

Worked Example:   Convert text to date in Excel

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 “/”.

Worked Example:   How to translate letters to numbers in Excel

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

Worked Example:   Split dimensions into three parts in Excel

Post navigation

Previous Post:

How to strip protocol and trailing slash from URL in Excel

Next Post:

How to get full workbook name and path in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to display conditional message with REPT function in Excel
  • Remove leading and trailing spaces from text in one or more cells in Excel
  • UNICHAR function: Description, Usage, Syntax, Examples and Explanation
  • How to create email address from name in Excel
  • How to use double quotes inside a formula in Excel
  • Get days before a date in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Count day of week between dates in Excel
  • Get age from birthday in Excel
  • Get work hours between dates custom schedule in Excel
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYS function: Description, Usage, Syntax, Examples and Explanation
  • YIELD function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • FV function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles