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!
Bookmarks