Skip to content

Instantly share code, notes, and snippets.

@dylanhthomas

dylanhthomas/excel-remove-trailing-slash.txt

Created June 18, 2013 16:36
Show Gist options
  • Star 10 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save dylanhthomas/5806991 to your computer and use it in GitHub Desktop.
Save dylanhthomas/5806991 to your computer and use it in GitHub Desktop.
Download ZIP
Remove the Trailing slash from a cell in Excel. This is especially handy when dealing with lots of urls. Replace "A1" with your cell.
Raw
excel-remove-trailing-slash.txt
=IF(RIGHT(A1,(LEN(A1)-(LEN(A1)-1)))="/",LEFT(A1,(LEN(A1)-1)),A1)
@maysolan
Copy link

Working. Thanks

@GauravKaushik01
Copy link

Thanks for the this, It worked like wow !

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment