Formula to find the last " \ " in a filepath and remove all after that
So I have an excel task that involves taking filepaths (C:\foo...) and
getting just the path (that is, removing the actual file name from the
path). I can't seem to get the SEARCH/FIND function to work since it is
always finding the first "\" in the file path (after the drive
designation) and only removes 3 or so characters.
Is there a formula that will allow me to trim after the last "\" in the
filepath?
Thanks in advance for any help!
No comments:
Post a Comment