Data Extraction from a cell

[dave_br]

is it possible to pull out data from within a cell? i have the following:

<TABLE style="WIDTH: 325pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=433><COLGROUP><COL style="WIDTH: 170pt; mso-width-source: userset; mso-width-alt: 8265" width=226><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5229" width=143><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 170pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=226>EK001 (Tvlr 12ltr BackPK)</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 107pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=143>4ME (Seasc/Enamel)</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64>000 (Sgl)</TD></TR></TBODY></TABLE>

this data is across cells a1, b1, c1 and i need to extract the data that is within the brackets.
however i also need the data in seperate cell that is not in the brackets.

any help is greatly appreciated!

thanks

 

[VoG]

Try

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

 

[dave_br]

works a treat for the information within the brackets, but is there a way to now extract the data that is not within the brackets?

dave

 

[Sektor]

=mid(a1,1,find("(",a1)-2)

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D	E
1	EK001 (Tvlr 12ltr BackPK)			Tvlr 12ltr BackPK	EK001
Sheet3