Find and return formula

[julieni]

Hoping to get some help. In a specific cell I'm looking to find text that begins with "CX" and return the remaining 4-5 letters behind it in a separate cell. The data that I'm looking for could be at the beginning or middle of text string. Basically, everything in red I'm looking to pull into a separate cell.
Thanks

UDL_CXDAD_Full Episode_Dallas-Ft. Worth DMA

CXTY_Full Episode Player_Geotarget Tyler DMA_8/13-8/19

Makegood_CXTY_Full Episode_Geotarget Tyler DMA

<tbody>
</tbody>

 

[Fluff]

Hi & welcome to MrExcel.
How about
=TRIM(LEFT(SUBSTITUTE(MID(A2,SEARCH("CX",A2),100),"_",REPT(" ",100)),100))

 

[julieni]

It works!!! Thank you so much!!

 

[Peter_SSs]

.. another possibility

=REPLACE(LEFT(A2,FIND("_",A2,FIND("CX",A2))-1),1,FIND("CX",A2)-1,"")

 

[julieni]

Thanks!!

 

[Fluff]

Glad we could help & thanks for the feedback