Get File name without Extension

[zezo2021]

hello friends
Get File name without Extension
sample of the file name is

02.14.2021 (1).xls

any idea or solution

Thanks in advance and your help is appreciated

 

[June7]

If file extension is always 3 characters, simply:
Left(x, Len(x) - 4)

Otherwise:
Left(x, InStrRev(x, ".")-1)

 

[Galaxiom]

If you are working with the FileSystemObject you can use the GetBaseName Method.

GetBaseName method (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[zezo2021]

Thanks for your help