EXTRACTFOLDERPATH

Returns only the folder path from a full file path.

value

The text you want to scramble.

Remarks

* The equivalent VBA function is EXTRACTFOLDERPATH

	A
1	test

1 - What is the

EXTRACTFOLDERNAME = ASAPEXTRACTFOLDERNAME(text, optional path_separator)

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

Parameters:
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.