EXTRACTFOLDERPATH
EXTRACTFOLDERNAME(text, optional path_separator)
Returns only the folder path from a full file path.
| text | The value or cell address from which you want to extract only the folder name. |
| path_separator | The path separator Optional, if omitted a backslash (\) is used. |
REMARKS
Returns the folder name from a combined filepath and filename. By default the formula uses a backslash (\) as separator, but optionally you can specify another separator.
For example =ASAPEXTRACTFOLDERNAME("D:\Projects\Archive\Client 1\Balance.xls") returns "D:\Projects\Archive\Client 1".
|
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext