22
Excel Formulas to Remove File Extension from Filename ~ Simple Tricks!!
Assume that you have a list of file names. Here you need to extract the file names only without its extension. How could you get them quickly? This article will introduce several tricks to remove the file extension from the file name in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- Use the below formula to remove a file extension from a file name in Excel.
- *LEFT * – This function helps to find out the one text string inside the other. Read more on the LEFT function.
- FIND – This function helps to find out the one text string inside the other. Read more on the FIND function.
- Filename – It represents the input value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Minus Operator (-) – This symbol will help to subtract any two values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Refer to the below example image.
- First, we will enter the input names in Column B.
- Now we need to extract the file name from these inputs.
- Select any cell and type the above-given formula.
- Finally, press the ** ENTER** key, you can get the result as shown below.
From this guide, you can get some clarification on how to remove the file extension from the file name in Excel. We welcome your comments and questions about this lesson
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
22