Hello
I've generated a list of files in a folder ...
-a---- 02/08/2021 16:18 32624 My File1.xlsx
-a---- 02/08/2021 16:19 19515 File2.xlsx
I need to return the file name excluding the file extension, e.g. My File1, File2
The file name starts at character 50, but can include spaces. I've tried various methods see below,
but can't get it quite right
=LEFT(RIGHT(A1, LEN(A1) -MATCH(2,1/(MID(A1,SEQUENCE(LEN(A1)),1)=" "))), LEN(RIGHT(A1, LEN(A1) -MATCH(2,1/(MID(A1,SEQUENCE(LEN(A1)),1)=" "))))-5)
=LEFT((MID(A1,50,LEN(A1))),FIND(".",MID(A1,50,LEN(A1))-1))
Any pointers much appreciated
Thanks in advance
Ron

