How to extract part of a filename in Excel

Posted on


I saw a post about using the CELL function to return and extract the filename as ABC.xlsx. The formula used was:


I only want to show ABC without the .xlsx filetype extension. How do I modify the formula to show only ABC?


=LEFT(CELL("filename",A1), LEN(CELL("filename",A1))-4)

Leave a Reply

Your email address will not be published. Required fields are marked *