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



[TABLE="width: 488"]
<tbody>[TR]
[TD]UDL_CXDAD_Full Episode_Dallas-Ft. Worth DMA[/TD]
[/TR]
[TR]
[TD]CXTY_Full Episode Player_Geotarget Tyler DMA_8/13-8/19[/TD]
[/TR]
[TR]
[TD]Makegood_CXTY_Full Episode_Geotarget Tyler DMA[/TD]
[/TR]
</tbody>[/TABLE]

 

[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