Split Column as per symbol

[goble]

Hello,

Would like to split 1st column like in the 3 next columns.

John Smith (Member since 1st July 2021) - Finance

John Smith

(Member since 1st July 2021)

- Finance

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1
2	John Smith (Member since 1st July 2021) - Finance	John Smith	(Member since 1st July 2021)	- Finance
Report

Cell Formulas
Range	Formula
B2	B2	=TRIM(LEFT(A2,FIND("(",A2)-1))
C2	C2	=MID(A2,FIND("(",A2),FIND(")",A2)-FIND("(",A2)+1)
D2	D2	=MID(A2,FIND(")",A2)+1,99)

 

[DanteAmor]

If you don't need the parentheses, it could be with a formula:

Dante Amor
	A	B	C	D
1
2	John Smith (Member since 1st July 2021) - Finance	John Smith	Member since 1st July 2021	- Finance
Hoja10

Cell Formulas
Range	Formula
B2:D2	B2	=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,")","("),"(",REPT(" ",99)),COLUMNS($B1:B1)*99-98,99))

 

[goble]

=MID(A2,FIND(")",A2)+1,99)

That's prefect !

 

[Fluff]

You're welcome & thanks for the feedback.

 

[goble]

If you don't need the parentheses, it could be with a formula:

Dante Amor
	A	B	C	D
1
2	John Smith (Member since 1st July 2021) - Finance	John Smith	Member since 1st July 2021	- Finance
Hoja10

Cell Formulas
Range	Formula
B2:D2	B2	=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,")","("),"(",REPT(" ",99)),COLUMNS($B1:B1)*99-98,99))

Thank you !