Extracting Words from a cell

[koreyjames]

Hey guys,

Really quick and easy one but for the life of me I cannot get it work.

I need to extract the names from the 'T' at the start of TBBC to the first space at the end before the Employee number.

TL-TBBCCABBILL C123456 TL-TBBCCARCPE C123456 TL-TBBCCABCPE D123456 TL-TBBCCABCPE D123456 <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

I am using =MID(Z9,FIND("-",Z9,FIND(" ",Z9)+1)+1,2) but it continues to return an error.

Anyone able to give me a quick hand in solving this one?

Thanks!

 

[Momentman]

Like this maybe

Excel 2010
	A	B
1	TL-TBBCCABBILL C123456	TBBCCABBILL
2	TL-TBBCCARCPE C123456	TBBCCARCPE
3	TL-TBBCCABCPE D123456	TBBCCABCPE
4	TL-TBBCCABCPE D123456	TBBCCABCPE
Sheet4

Cell Formulas
Range	Formula
B1	=MID(A1,FIND("-",A1)+1,FIND(" ",A1)-FIND("-",A1)-1)

 

[koreyjames]

You my friend are a legend, thank you very much!

 

[azumi]

Left(a1,find(" ",trim(mid(substitute(a1,"-",rept(" ",99)),100,99)),1)-1)