danwhite85
6/18/2013 - 4:36 PM

Remove the Trailing slash from a cell in Excel. This is especially handy when dealing with lots of urls. Replace "A1" with your cell.

Remove the Trailing slash from a cell in Excel. This is especially handy when dealing with lots of urls.

Replace "A1" with your cell.

excel-remove-trailing-slash.txt
content_copyfile_download
=IF(RIGHT(A1,(LEN(A1)-(LEN(A1)-1)))="/",LEFT(A1,(LEN(A1)-1)),A1)