Formula to identify Segments of text and percentages

It can be built into the formula too. It's a BIT more complicated than normal in your case as I am using the ; as the delimiter to build up the XML string... However, this will safely allow the presence of & in your strings:

=FILTERXML("<A><B>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,";","¦"),"&","#38;"),"¦","</B><B>")&"</B></A>","//B[contains(.,'"&MAX(IF(ISERROR(1*MID(A2,ROW($1:$1000),3)),0,1*MID(A2,ROW($1:$1000),3)))&"')]")

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.