Remove all text after last "/" character

[chive90]

In D I have URL strings of varying lengths and varying amounts of "/" characters.

In E I would like all of the URL string to display minus anything after the final "/".

Is there a formula I can enter for this?

Thank you

 

[Fluff]

How about

=LEFT(A2,FIND("^",SUBSTITUTE(A2,"/","^",LEN(A2)-LEN(SUBSTITUTE(A2,"/","")))))

 

[chive90]

How about

=LEFT(A2,FIND("^",SUBSTITUTE(A2,"/","^",LEN(A2)-LEN(SUBSTITUTE(A2,"/","")))))

Thanks Fluff that's perfect.

For some other instances, can I use an extract of text in C2 as the cut off point of what I'd like D2 to be displayed as in E2?

e.g.

C2 = /test/bloggs joe/
D2 = http://folder1/folder2/folder3/test/bloggs joe/joe1/joe2/file.pdf
Desired result in E2 = http://folder1/folder2/folder3/test/bloggs joe/

Thanks!

 

[Fluff]

How about

=LEFT(D2,FIND(C2,D2)+LEN(C2)-1)

 

[chive90]

How about

=LEFT(D2,FIND(C2,D2)+LEN(C2)-1)

Thanks a lot

 

[Fluff]

You're welcome & thanks for the feedback.