How to extract text before or after a second hyphen(-) using formula

[sayseee]

I have my data in column A and I want to separate the strings as seen in column HOME and AWAY.

DATA	HOME	AWAY
Al-Faisaly - Al Taee	Al-Faisaly	Al Taee
Al-Nassr - Al-Shabab	Al-Nassr	Al-Shabab
Al-Shabab - Al-Ittihad FC	Al-Shabab	Al-Ittihad FC
Al-Hazem - Al-Shabab	Al-Hazem	Al-Shabab
Al-Shabab - Al-Fateh	Al-Shabab	Al-Fateh

using normal LEFT formula

LEFT(A2,FIND("-",A2)-1)

in column B, I get as below and this is not what i need.

WettPoint.xlsm
	A	B	C
1	DATA	HOME	AWAY
2	Al-Faisaly - Al Taee	Al	Al Taee
3	Al-Nassr - Al-Shabab	Al	Al-Shabab
4	Al-Shabab - Al-Ittihad FC	Al	Al-Ittihad FC
5	Al-Hazem - Al-Shabab	Al	Al-Shabab
6	Al-Shabab - Al-Fateh	Al	Al-Fateh
Sheet3

Cell Formulas
Range	Formula
B2:B6	B2	=LEFT(A2,FIND("-",A2)-1)

How do I get through this?
Thank you

 

[shift-del]

Hi

=FILTERXML("<y><z>"&SUBSTITUTE(A2," - ","</z><z>")&"</z></y>","//z[position()=1]")
=FILTERXML("<y><z>"&SUBSTITUTE(A2," - ","</z><z>")&"</z></y>","//z[position()=2]")

 

[Snakehips]

@sayseee Another way.

MXLBook1.xlsm
	A	B	C
1	DATA	HOME	AWAY
2	Al-Faisaly - Al Taee	Al-Faisaly	Al Taee
3	Al-Nassr - Al-Shabab	Al-Nassr	Al-Shabab
4	Al-Shabab - Al-Ittihad FC	Al-Shabab	Al-Ittihad FC
5	Al-Hazem - Al-Shabab	Al-Hazem	Al-Shabab
6	Al-Shabab - Al-Fateh	Al-Shabab	Al-Fateh
7	Al Taee - Al-Shabab	Al Taee	Al-Shabab
8
Sheet6

Cell Formulas
Range	Formula
B2:B7	B2	=TRIM(LEFT(SUBSTITUTE(A2," - ",REPT(" ",99)),99))
C2:C7	C2	=TRIM(RIGHT(SUBSTITUTE(A2," - ",REPT(" ",99)),99))

Hope that helps.

 

[Peter_SSs]

.. and another

22 09 08.xlsm
	A	B	C
1	DATA	HOME	AWAY
2	Al-Faisaly - Al Taee	Al-Faisaly	Al Taee
3	Al-Nassr - Al-Shabab	Al-Nassr	Al-Shabab
4	Al-Shabab - Al-Ittihad FC	Al-Shabab	Al-Ittihad FC
5	Al-Hazem - Al-Shabab	Al-Hazem	Al-Shabab
6	Al-Shabab - Al-Fateh	Al-Shabab	Al-Fateh
Home Away

Cell Formulas
Range	Formula
B2:B6	B2	=LEFT(A2,FIND(" -",A2)-1)
C2:C6	C2	=REPLACE(A2,1,LEN(B2)+3,"")

 

[sayseee]

All your solutions worked, Thank you.

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.