I have a single column in Excel which has a file and folder path. e.g. C:\1_Folder\2_Folder\3_Folder\my_file.txt
I would like to extract the name of the final folder and place this in a new column. In this example, 3_Folder.
Can this be achieved using a formula rather than VBA?
Edit: the number of nested folders can vary.