Separate in to different columns

[SeanLCA]

What is the formula that would separate the following into different columns.

	Sport 1	Sport 2	Sport 3	Sport 4	Sport 5	Sport 6	Sport 7
Baseball > Basketball > Football > Soccer > Hockey > Pickleball > Golf

The desire result in each column without including >:

	Sport 1	Sport 2	Sport 3	Sport 4	Sport 5	Sport 6	Sport 7
Baseball > Basketball > Football > Soccer > Hockey > Pickleball > Golf	Baseball	Basketball	Football	Soccer	Hockey	Pickleball	Golf

 

[kweaver]

Please change your profile to indicate which version of Excel you are running.

If you're using 365, this might be what you want:

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H
1	Baseball > Basketball > Football > Soccer > Hockey > Pickleball > Golf	Baseball	Basketball	Football	Soccer	Hockey	Pickleball	Golf
Sheet4

Cell Formulas
Range	Formula
B1:H1	B1	=TEXTSPLIT(A1," > ")
Dynamic array formulas.

 

[SeanLCA]

Correction
What is the formula that would separate the (Numbers) into different columns.

	Sport 1	Sport 2	Sport 3	Sport 4	Sport 5	Sport 6	Sport 7
Baseball (805) > Basketball (705) > Football (605) > Soccer (505)> Hockey (405)> Pickleball (305)> Golf (205)

The desire result in each column without including >:

	Sport 1	Sport 2	Sport 3	Sport 4	Sport 5	Sport 6	Sport 7
Baseball (805) > Basketball (705) > Football (605) > Soccer (505)> Hockey (405)> Pickleball (305)> Golf (205)	(805)	(705)	(605)	(505)	(405)	(305)	(205)

 

[kweaver]

If you're consistent with your spacing before and after the ">" and inside the parens

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H
2	Baseball (805) > Basketball (705) > Football (605) > Soccer (505) > Hockey (405) > Pickleball (305) > Golf (205)	(805)	(705)	(605)	(505)	(405)	(305)	(205)
Sheet4

Cell Formulas
Range	Formula
B2:H2	B2	=RIGHT(TEXTSPLIT(A2," > "),5)
Dynamic array formulas.

 

[SeanLCA]

If you're consistent with your spacing before and after the ">" and inside the parens

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H
2	Baseball (805) > Basketball (705) > Football (605) > Soccer (505) > Hockey (405) > Pickleball (305) > Golf (205)	(805)	(705)	(605)	(505)	(405)	(305)	(205)
Sheet4

Cell Formulas
Range	Formula
B2:H2	B2	=RIGHT(TEXTSPLIT(A2," > "),5)
Dynamic array formulas.

Thanks for your help

 

[kweaver]

Glad to help. If that was the solution, please mark it accordingly.