Friday, 31 January 2014

How does Google make you an IT guru?

If you have an IT problem like what I had this afternoon what do you do? Imagine I wanted to insert the name of my excel file into one of the cell of the same excel file.

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