Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How to get Excel workbook path only

If you want to get the workbook path (directory) only, you can do so with a formula that uses the LEFT and the FIND function. The result will look something like this:

Worked Example:   Save As in Excel Explained
Drive:\path\to\file\   //Windows
Drive:path:to:file:    //Mac




How the formula works

The cell function is used to get the full file name and path:


The result looks like this:


The full file name and path are fed into the LEFT function, which is used to extract just the full directory path.

Worked Example:   How to split text string at specific character in Excel

The number of characters to extract by locating the the position of the left square bracket “[” with FIND and subtracting 1:

Worked Example:   How to extract substring in Excel

Leave a Reply

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