WORKBOOKFILEEXTENSION

Returns the file extension of the active workbook.



'rgeCellRange - (Optional) A cell in the workbook you want the name of.

You can use the following formula

=MID(CELL("Filename",A1),FIND(".",CELL("Filename",A1),FIND("[",CELL("Filename",A1)))+1, 
FIND("]",CELL("Filename",A1),1)-FIND(".",CELL("Filename",A1),FIND("[",CELL("Filename",A1)))-1)"

Thank you to - cpearson.com/excel/FileFolderNames.aspx



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext