On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Sunday, May 18, 2014

Cell() Function to Pick the File Name & File Path By MS-Excel Formula

There may be times when you need to insert the name of the current workbook or worksheet in to a cell.

This can be done by using the CELL() function, shown below.

 C:\Users\welcome\Downloads\[Test File - Excel Help.xls] Filename formula  

The problem with this is that it gives the complete path including drive letter and folders.
To just pick out the workbook or worksheet name you need to use text functions.

To pick the Path


To pick the Workbook name

 Test File - Excel Help.xls  

To pick the Worksheet name.

 Filename formula  

No comments:

Post a Comment

Popular Posts