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'.