getting a specific text within a data

[top00001]

excel101.xlsx

Hi there! I need a help here. Kindly see the attached file.. Thank you!

[AlKey]

Try this one

=IFERROR(TRIM(RIGHT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(MID(B2,FIND("-",B2),255)," ",REPT(" ",255)),1,255*5))," ",REPT(" ",255)),255*2)),"")

Row\Col	B	C
1		Results
2	910-San Francisco Giants 10 PK 909-Kansas City Royals	10 PK
3	Kansas City Royals [MLBWS] @ 0.950
4	910-San Francisco Giants 10 L 909-Kansas City Royals	10 L
5	Kansas City Royals [MLBWS] @ 0.950
6	907-Kansas City Royals 10 +50 908-San Francisco Giants	10 +50
7	Kansas City Royals [MLBWS] @ 0.950
8	907-Kansas City Royals 5 L 908-San Francisco Giants	5 L
9	Kansas City Royals [MLBWS] @ 0.950
10	916-Los Angeles Dodgers 5 -50 915-St. Louis Cardinals	5 -50
11	St. Louis Cardinals [MLBWS] @ 0.950
12	916-Los Angeles Dodgers 6 PK 915-St. Louis Cardinals	6 PK
13	St. Louis Cardinals [MLBWS] @ 0.950

[top00001]

Try this one

=IFERROR(TRIM(RIGHT(SUBSTITUTE(TRIM(MID(SUBSTITUTE(MID(B2,FIND("-",B2),255)," ",REPT(" ",255)),1,255*5))," ",REPT(" ",255)),255*2)),"")

Row\Col	B	C
1		Results
2	910-San Francisco Giants 10 PK 909-Kansas City Royals	10 PK
3	Kansas City Royals [MLBWS] @ 0.950
4	910-San Francisco Giants 10 L 909-Kansas City Royals	10 L
5	Kansas City Royals [MLBWS] @ 0.950
6	907-Kansas City Royals 10 +50 908-San Francisco Giants	10 +50
7	Kansas City Royals [MLBWS] @ 0.950
8	907-Kansas City Royals 5 L 908-San Francisco Giants	5 L
9	Kansas City Royals [MLBWS] @ 0.950
10	916-Los Angeles Dodgers 5 -50 915-St. Louis Cardinals	5 -50
11	St. Louis Cardinals [MLBWS] @ 0.950
12	916-Los Angeles Dodgers 6 PK 915-St. Louis Cardinals	6 PK
13	St. Louis Cardinals [MLBWS] @ 0.950

Wow! it works!! thank you so much!!