like below fixes the issue You already have logic for finding the position of the last "\" character in string. You can use the same logic for finding the position of the last "." character in string. Then the difference of those two numbers minus one will be the length of the file name without the file extension. Use this length for the num_chars argument ot the MID function. For example...

```
=IFERROR(MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"\",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,FIND(CHAR(1),SUBSTITUTE(A1,".",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))-FIND(CHAR(1),SUBSTITUTE(A1,"\",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))-1),"")
```