Rated: T|English|Romance/Drama|Chapters: 25|Words: 85,347| Reviews: 326|Favs: 117|Follows: 270|Updated: 7h ago|Published: Jun | 9, 2016 [Draco M.,...

i need an excel formula to extract a certain Part of a string text between two character("|" &" |Complete*" there in green). i Need help again on the same question for a formula in excel. but i need it to stop at the (Purple |) instead of the number of Characters. This is for a large data set that i don't want to count Characters for each one.