Formula to get text after the 7th forward slash

[ezflow]

Hi,
I'm trying to write a formula that would get the text after the 7th forward slash

Value of cell A6

//nchprv/prod/data/Dept-HR/HR-MBU/Job Evaluation/2021 JE/2021_Finance

Result: Job Evaluation/2021 JE/2021_Finance

[#2 · Accepted solution]

@ezflow 

=RIGHT(A6,LEN(A6)-FIND("|",SUBSTITUTE(A6,"/","|",7)))