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
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext