Nested Search Function Excel Formula

[Haseeb A]

If always be a "_" after 'Acrobat*', try this version.

=REPLACE(O9,1,FIND("_",O9,SEARCH("Acrobat",O9)),"" )

[Rick Rothstein]

If always be a "_" after 'Acrobat*', try this version.

=REPLACE(O9,1,FIND("_",O9,SEARCH("Acrobat",O9)),"" )

Assuming the word "Acrobat" cannot appear before the words "AcrobatPro" or "AcrobatFamily", Haseeb's formula is nice and simple and gets my vote. However, if the word "Acrobat" could possibly appear before the words "AcrobatPro" or "AcrobatFamily", then you could consider a formula like this one...

=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(O1,"AcrobatFamil y","AcrobatPro"),"_AcrobatPro_",REPT(" ",999)),999))