bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 734
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have the following formula in A1 to show the current file Name
Code:
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