Extract Folder / File Name From File path 4th back slash

Hi folks,

how do i extract the file names or folder names after the fourth back slash?

After some googling i came across this


=FIND("\",D10,FIND("\",D10,FIND("\",D10,FIND("\",D10)+1)+1)+1)

it only returns a number -

Example file path
C:\Users\Work\Dropbox\Docs\SH23\1. Word
C:\Users\Work\Dropbox\Docs\PB34\2. Excel

cheers for any ideas
sl

Thanks Ben,

done nicely!

Have a good Evening

sl