title: Formula to find the last " \ " in a filepath and remove all after that
body: <p>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.</p>
  
  <p>Is there a formula that will allow me to trim after the last "\" in the filepath?</p>
  
  <p>Thanks in advance for any help! </p>