title: triming extension from filename in Excel
body: <p>I have this formula. This works great but fails when there are 5 characters including the dot.</p>
  
  <p>For example,</p>
  
  <p>abcdefgh.pdf   =TRIM(LEFT(A1,LEN(A1)-4))  gives me abcdefgh
  xyz.xlsx  =TRIM(LEFT(A2,LEN(A2)-4)) gives me xyz.</p>
  
  <p>Is there a formula that looks for the last dot and trims everything after the last dot?</p>