Custom Excel VBA Function to Extract FileName from FilePath

This is a custom UDF (user-defined function) that I created in Excel VBA that extracts the filename and extension from a file path. In simple terms, the process begins from the right and finds the first "\", since you can't have certain characters including the "\" in the file name. You can download this workbook from the link below:

https://www.nomorelinesla.com/wp-content/uploads/2022/03/FileName-Extraction-Function.zip