Formula to extract part of file name

[howard]

I would like a formula to extract the the month and year in the file name, which will always be after ISTL and before the dot

for eg. BR1 Report pertaining for ISTL Feb 2021.xlsm i need in this example Feb 2021 extracted It would be appreciated if someone could kindly assist me

 

[Michael M]

Try

=MID(LEFT(A1,FIND(".",A1)-1),FIND(" ",A1)+1,LEN(A1))

 

[howard]

Thanks for the help Michael. I need just the month and year to be extracted

See link below

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[Michael M]

edit

 

[howard]

I extracts

"Report pertaining for ISTL Feb 2021" instead of Feb 2021

 

[Peter_SSs]

Assuming only one "." in the file name, try

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(".",A1)-1)," ",REPT(" ",10)),20))

 

[Peter_SSs]

Actually, re-reading, this should do it

=MID(A1,FIND(" ISTL ",A1)+6,8)

 

[howard]

Thanks Peter, it works perfectly

 

[Peter_SSs]

Cheers.