title: Get parent folder path from file path using cell formula
body: <p>In column <code>A</code> I have 20000 rows with filename with file path</p>
  
  <blockquote>
    <p>"C:\person\microsoft\ygkyg\mmddyy\filename.xls"<br>
     "\server-41\performance\mmddyy\filename.doc"<br>
     .....<br>
    etc.</p>
  </blockquote>
  
  <p>In column <code>B</code> I just want to get the parent folder path. </p>
  
  <p>Could someone help me with the formula? I tried this but it's giving me the file name.</p>
  
  <pre><code>=MID(a1,FIND(CHAR(1),
      SUBSTITUTE(a1,"\",CHAR(1),LEN(a1)-LEN(SUBSTITUTE(a1,"\",""))))+1,LEN(a1))
  </code></pre>