What I did? I just opened my friend Google, typed in my problem, submit it and bang. In most of the cases I can find the ready to use, cut and paste solution. I can do programming but in this way it is just so easy. Nowadays you don't even need to know how to write functions in Excel, Cut and Paste, that's it.
Inserting the current Excel file name in a cell. Enter the following formula as an array formula to display the current file name and active worksheet name:
=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH("\",CELL("filename"),ROW(1:255)))))
Source: http://office.microsoft.com/en-gb/excel-help/inserting-the-current-excel-file-name-in-a-cell-HA001034627.aspx
I just wondering how lucky we are.
No comments:
Post a Comment