Nested Search Function Excel Formula

[trankim]

Thank you...however, see below:

1) Formula used: =MID(SUBSTITUTE(SUBSTITUTE(O9,"_AcrobatPro","|")," _AcrobatFamily","|"),SEARCH("|",SUBSTITUTE(SUBSTIT UTE(O9,"_AcrobatPro","|"),"_AcrobatFamily","|"))+2 ,255)

The formula worked for "AcrobatPro" but for "AcrobatFamily", it showed "crobatFamily...."
Results:
create-fillable-pdf-forms.html ad_us_AcrobatPro_create-fillable-pdf-forms.html
crobatFamily_create-pdf-web-forms-builder.html ad_us_AcrobatFamily_create-pdf-web-forms-builder.html


2) Formula used: =TRIM(MID(SUBSTITUTE(SUBSTITUTE(O9,"AcrobatFamily_ ","AcrobatPro_"),"AcrobatPro_",REPT(" ",200)),200,255))
Formula with the "Trim" worked for AcrobatPro, but the results were blank for "AcrobatFamily".

Results
create-fillable-pdf-forms.html ad_us_AcrobatPro_create-fillable-pdf-forms.html
ad_us_AcrobatFamily_create-pdf-web-forms-builder.html


3) Formula used: =REPLACE(SUBSTITUTE(O9,"AcrobatFamily","AcrobatPro "),1,SEARCH("AcrobatPro",SUBSTITUTE(O9,"Acroba tFam ily","AcrobatPro"))+10,"")
This is the only formula that worked and gave the correct output for both AcrobatFamily and AcrobatPro. THANK YOU!!!!!

[Admin]

Thank you...however, see below:

2) Formula used: =TRIM(MID(SUBSTITUTE(SUBSTITUTE(O9,"AcrobatFamily_ ","AcrobatPro_"),"AcrobatPro_",REPT(" ",200)),200,255))
Formula with the "Trim" worked for AcrobatPro, but the results were blank for "AcrobatFamily".

Results
create-fillable-pdf-forms.html ad_us_AcrobatPro_create-fillable-pdf-forms.html
ad_us_AcrobatFamily_create-pdf-web-forms-builder.html

I think that's because I see there is a space after AcrobatFamily. Try without the space.