Remove values before Third "-" in Cell

[Ananthak275]

Need to remove values after the third hyphen ("-").

Eg:

Home Plan - Textline - User - Personal Line - Tray Yun	Home Plan - Textline - User
Mobile Plan - Landline - Company - Personal Line - Scotia	Mobile Plan - Landline - Company

 

[johnnyL]

Book1
	A	B	C
1	Home Plan - Textline - User - Personal Line - Tray Yun	Home Plan - Textline - User
2	Mobile Plan - Landline - Company - Personal Line - Scotia	Mobile Plan - Landline - Company
3
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=LEFT(A1,FIND(" & Chr(13) & ",SUBSTITUTE(A1,"-"," & Chr(13) & ",3))-1)

 

[BSALV]

Map2
	A	B
1	Home Plan - Textline - User - Personal Line - Tray Yun	Home Plan - Textline - User
2	Mobile Plan - Landline - Company - Personal Line - Scotia	Mobile Plan - Landline - Company
Blad1

Cell Formulas
Range	Formula
B1:B2	B1	=TRIM(LEFT(SUBSTITUTE(A1," - ",REPT(" ",500),3),200))

 

[Fluff]

Another option

+Fluff 1.xlsm
	A	B
1
2	Home Plan - Textline - User - Personal Line - Tray Yun	Home Plan - Textline - User
3	Mobile Plan - Landline - Company - Personal Line - Scotia	Mobile Plan - Landline - Company
Sheet3

Cell Formulas
Range	Formula
B2:B3	B2	=TRIM(REPLACE(A2,FIND("^",SUBSTITUTE(A2,"-","^",3)),100,""))