find filename in path regardless of number of subfolders

Hello good people of the Excel forum!

I was wondering if you could help me with this problem:

let's say I have a list of files in column A:

/folder/subfolder1/subfolder2/subfolder3/file1.txt
/folder/subfolder1/subfolder2/file2.txt
/folder/subfolder1/file3.txt
/folder/file4.txt

in column B I would like to see just the filenames:

file1.txt
file2.txt
file3.txt
file4.txt

How can I achieve this?

On the internet I found this forumule which looks promising but unfortunately finds the first slash (instead of the last) and prints what's to the right of that slash:

=RIGHT(C2; LEN(C2) - SEARCH("/";C2))

there seem to be other solutions to this problem available online, but honestly, I don't fully understand what they are supposed to do and also they don't seem to work...

Hello daffodil11,

You are awesome.


Thanks so much!