Use text from one cell with another cell to display desired result in new column?

[chive90]

In F2 I have a partial URL string like this: http://test/subtest/site/site2/

In C2 I have the full URL string like this: http://test/subtest/site/site2/libraryname/folder/document.doc

In M2 I would like the following: /folder/document.doc
i.e. everything after the libraryname

Is it possible to use F2 with C2 to achieve this? Something like: in M2, omit all F2 text from C2 plus also omit text stored after the next '/' character in order to return just the folder string onwards?
What is the best way to achieve this?

Thanks

 

[AlphaFrog]

Try something like this...

=MID(C2,LEN(F2)+FIND("/",MID(C2, LEN(F2)+1,99)),99)