Need help with text extract formula

[SEMMatt]

Hello,

How can I get all of the text after the phrase "Detail/" in a new column? The identifier will always be "Detail/"

http://mywebsite.com/Plan_Detail/AB/CD/EFG/1234

Thanks,

[alansidman]

Assume your data is in A1 and B1 =MID(A1,FIND("Detail/",A1)+7,LEN(A1)-FIND("Detail/",A1))

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[FDibbins]

Little late to the party, but here is another 1...
=MID(A1,SEARCH("detail/",A1,1)+7,99)

[SEMMatt]

Thanks to all! (I choose Ford's solution as it seemed simplest to me).

[TMS]

You're welcome. Thanks for the rep.

[FDibbins]

Happy to help and thanks for the feedback