Help to extract partial text from a cell

Originally Posted by AlKey

=SUBSTITUTE(MID(C2,SEARCH("Multiple Sclerosis ",C2)+LEN("Multiple Sclerosis ("),3),")","")

This works great too, thank you! I haven't come across SUBSTITUTE before. Will go and look up.