Extracting text out of a string in a cell

[Peter Davison]

I have the following folder structure in Cell S2 -

C:\Cluster Insight\Micro Development\Raw Data\Breakfast Cereals\ImportFile.xlsx

I want to be able to put a formula in Cell S3 that returns me "Breakfast Cereals"
I have tried to build the formula from google help (below), but I can't work out what is wrong. I'm also not sure what the CHAR(1) is doing?
This is my formula, which has an error

=MID(S2,FIND(CHAR(1),SUBSTITUTE(S2,”\”,CHAR(1),4))+1,FIND(CHAR(1),SUBSTITUTE(S2,”\”,CHAR(1),5)) – FIND(CHAR(1),SUBSTITUTE(S2,”\”,CHAR(1),4))-1)

Any help or guidance would be great.
Thanks

 

[Fluff]

How about

=CHOOSECOLS(TEXTSPLIT(S2,"\"),-2)

 

[Peter Davison]

Wow that is perfect and looks so simple.
Thank you so much for your help.

 

[Fluff]

You're welcome & thanks for the feedback.