Formula to separate text

[ashani]

hi experts,

I wonder if someone could please guide me the relevant formula to separate text from the cell. So currently my text appears like this :

(1234) Abc Def

I would like just '1234' (no brackets) in Column A and 'Abc Def' in Column B

I would really appreciate your help.

thank you

 

[Michael M]

assuming your text is in column "C"
for text within the brackets

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

for text after the brackets

=RIGHT(C1,LEN(C1)-SEARCH(") ",C1))

 

[Dave Patton]

TextBefore.xlsm
	A	B	C
1
2	(1234) Abc Def	1234	Abc Def
3
3h

Cell Formulas
Range	Formula
B2	B2	=TEXTAFTER(TEXTBEFORE(A2,")"),"(")
C2	C2	=TEXTAFTER(A2," ")

 

[Rick Rothstein]

Assuming your text is representative of your actual data and is located in cell C2, put this single formula in cell A2...

=TEXTSPLIT(MID(C2,2,LEN(C2)),") ")

 

[Peter_SSs]

No better, but just another way ..
=DROP(TEXTSPLIT(C2,{"(",") "}),,1)