Note: because this formula finds the first occurrence of “.
“, it will remove all file extensions when there is more than one.
For example, =LEFT(“apple”,3) returns “app”.
When the text is not found, FIND returns a #VALUE error.
Remove file extension from filename
To remove a file extension from a file name, you can use a formula based on the LEFT and FIND functions. In the example shown, the formula in C5 is: =LEFT(B5,FIND(".",B5)-1)
