Differences

This shows you the differences between two versions of the page.

--- software:microsoft:excel [2016/10/01 01:26] – created superwizard
+++ software:microsoft:excel [2018/06/29 19:58] (current) – superwizard
@@ Line 1: / Line 1: @@
+====== How To Quickly Extract Filename From Full Path In Excel ======
+From: https://www.extendoffice.com/documents/excel/1431-excel-extract-filename-from-full-path.html
+folder name filename path
+<code>
+Function FunctionGetFileName(FullPath As String) As String
+'Update 20140210
+Dim splitList As Variant
+splitList = VBA.Split(FullPath, "\")
+FunctionGetFileName = splitList(UBound(splitList, 1))
+End Function
+</code>
 ====== How to resolve crash and stability issues - OffCAT tool ======