Remove duplicates from a string only from right

Hi, I have a problem and surprisingly I cannot find easy answer to this. Is there a way to use formula (even complexed one) to remove repeating signs or letters ONLY from the end of a string in excel? For example to remove all "\" from the end of strings below (each would be in a separate row), but leaving "\" in the rest of the string:

\\emea.com\folder_01\subfolder\many_files\\\
\\emea.com\folder_02\subfolder2\something\\\\\
\\emea.com\folder_03\sub\\

There will be hundreds of rows so I need one formula to drag down...

Thanks!

This array-entered** formula should also work...

Formula:

=LEFT(A1,MAX(IF((MID(A1,ROW(1:300),1)<>"\")*LEN(MID(A1,ROW(1:300),1)),ROW(1:300))))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

If your text always begin with double backslash then you can use this formula

=LEFT(A1,LEN(TRIM(SUBSTITUTE(A1,"\"," ")))+2)

Originally Posted by Adtxc

If your text always begin with double backslash then you can use this formula

=LEFT(A1,LEN(TRIM(SUBSTITUTE(A1,"\"," ")))+2)

What about if a directory name begins or ends with a space or has two or more consecutive spaces in its name? Not likely but definitely possible.