Problem description & analysis

Here is Excel file book1.xlsx, as shown below:

We are trying to get directory names in the 6^th level of a specific path string. The desired result is as follows:

Solution & explanation

Load ExcelRaq.xll add-in in Excel.

Enter the following formula in cell A4: =esproc("=?.split(""\\"")(6)",A1)

Enter the following formula in cell A5: =esproc("=?.split(""\\"")(6)",A2)

To get the final result.

Q & A Collection

https://stackoverflow.com/questions/63779450/return-folder-name-from-string-formula