Returns only the file name from a full file path.

valueThe text you want to scramble.


* The equivalent VBA function is EXTRACTFILENAME


1 - What is the

EXTRACTFILENAME = ASAPEXTRACTFILENAME(text, optional path_separator)

Returns the file name from a full path and filename. By default the formula uses a backslash (\) as separator, but optionally you can specify another separator.
For example =ASAPEXTRACTFILENAME("D:\Projects\Archive\Client 1\Balance.xls") returns "Balance.xls".

text = The value or cell address from which you want to extract only the file name
path_separator = The path separator. Optional, if omitted a backslash (\) is used.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext