A proof list contains both proofs/june/route.pdf and proofs/map.pdf. Count the separator from the end so the number of folder levels can vary.

Find the rightmost slash

Put the path in A2 and enter this in B2 in a compatible spreadsheet:

=TEXTAFTER(A2,"/",-1,0,0,"Check path")

The third argument finds the last slash. The next two zeros use case-sensitive matching and keep the end of the text from counting as another slash. The last argument is the fallback for a missing delimiter.

Paths proofs/june/route.pdf and proofs/map.pdf return route.pdf and map.pdf.

Illustrated extraction. A negative occurrence starts at the right end.

Review rows that are not full file paths

Try route.pdf without a separator and expect Check path. Try proofs/june/ and check the empty tail. Decide whether that row names a folder before treating it as an extracted filename.

A name without a slash returns Check path, and a trailing slash leaves an empty final segment.

Illustrated review cases. Keep the source path visible.

Keep the source path alongside the filename, especially if different folders contain the same filename. If your export uses backslashes, use its actual separator. Microsoft’s TEXTAFTER argument reference.