Extracting Month and Year from File Name

[bearcub]

I have the following formula in A1 to show the current file Name

MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Result in A1:
Aug 2018 New Employee-Term File.xlsx

[code//] <- What is the correct syntax so it shows up as code (I forgot how to do it)

I would like to extract the month and year portion of the file name.

I did try using the left combined with the Search and Find functions but was unsuccessful.

Thank you for your help,

Michael

 

[bearcub]

Wow, this is great! Interesting how Excel allows you to use different recipes to get the same result. Really cool stuff! Thank you Peter

 

[Peter_SSs]

Wow, this is great! Interesting how Excel allows you to use different recipes to get the same result. Really cool stuff! Thank you Peter

You're welcome.