title: Excel formula to extract file name from paths without file extension
body: <p>I have this excel formula which I'm hoping can be amended to extract the file name <strong>without the file extension</strong>. I know this can be done over two formulas but it would make the process I am working with a whole lot easier. I'm also trying to avoid <code>VBA</code> as I don't have any knowledge on it.</p>
  
  <pre><code>=IFERROR(MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"\",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,LEN(A1)),"")
  </code></pre>
  
  <p>Thanks!</p>