Formula Help Please

[Dazzawm]

I have cells with various lengths of data. I need any data that starts with CU to be extracted or copied from the cell. The number CU1234 for example could be anywhere within the cell amongst other data. Thanks

Example

Sheet1

*	Y	Z
10	Before	After
11	Done:IIS042;Lemon:CP003;Fuel:CU1092	CU1092
12	Done:IIS070;;Fuel:CU1210:Lemon:CP037	CU1210

<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 282px"><COL style="WIDTH: 282px"></COLGROUP><TBODY>
</TBODY>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

 

[Andrew Poulsom]

If it's always 6 characters:

=IFERROR(MID(Y11,SEARCH("CU",Y11),6),"")

 

[Dazzawm]

Perfect, thanks Andrew.

 

[binuk]

=iferror(left(right(b11,len(b11)-find("cu",b11,1)+1),find(":",right(b11,len(b11)-find("cu",b11,1)+1),1)-1),right(b11,len(b11)-find("cu",b11,1)+1))

 

[binuk]

Its Case Sensitive & will take any length Character

=IFERROR(LEFT(RIGHT(B12,LEN(B12)-FIND("CU",B12,1)+1),FIND(":",RIGHT(B12,LEN(B12)-FIND("CU",B12,1)+1),1)-1),RIGHT(B12,LEN(B12)-FIND("CU",B12,1)+1))