# excel

split by delimeter and take just one part  
 =TAKE(DROP(TEXTSPLIT(\[@FullName\],"\\"), 0, 6), 1, 1)

- Split the target into a table where each column is a path segment  
- Drop the first 6 columns  
- Take a single (top leftmost) cell from that table