How to insert the Current file path to a Cell in Microsoft Excel ?

Do you want to insert the current excel workbook’s file path in to a cell in Microsoft Excel ?. You can use the formula to perform this.

How to insert the Current file path to a Cell in Microsoft Excel ?

Just paste the following formula in to the cell where you want to display the path of the file and press the enter key.

=LEFT(CELL(“filename”),FIND(“[“,CELL(“filename”),1)-1)

This will display the full path of the current file in the cell as shown in the screenshot.

image

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...