top of page

Excel formula to extract folder path

The Excel formula posted here by barry houdini, allows you to pull the the folder path in a file path - the path absent the file name. So this formula:


. . . references the file path in cell A1.

For this file path:


. . . the formula will pull the path 'C:\MyDocuments\CSuite'.

bottom of page