Need a excel formula

[aryanaveen]

Hi All,

Can someone please help me with a formula for below situation.
in below situation I need a formula in column B which will extract from right till first "-" from right, formula in column C should extract from right till second "-"

	A	B	C	D
1	ABC Com - INC - 123 - XYZ	XYZ	123 - XYZ	INC - 123 - XYZ
2
3

 

[jtakw]

Oops, copied and pasted incorrectly, corrected now:

Book3.xlsx
	A	B	C	D	E	F	G	H	I
1	ABC Com - INC - 123 - XYZ	XYZ	123 - XYZ	INC - 123 - XYZ
2	ABCde Com - xyzINC - 456 - 1xyi23 - 123XYZ	123XYZ	1xyi23 - 123XYZ	456 - 1xyi23 - 123XYZ	xyzINC - 456 - 1xyi23 - 123XYZ
3	1 - 2 - a - b - cde - xyz - 12345 - abc	abc	12345 - abc	xyz - 12345 - abc	cde - xyz - 12345 - abc	b - cde - xyz - 12345 - abc	a - b - cde - xyz - 12345 - abc	2 - a - b - cde - xyz - 12345 - abc
Sheet843

Cell Formulas
Range	Formula
B1:I3	B1	=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE($A1,"-","-"&REPT(" ",100)),COLUMNS($B1:B1)*100)),$A1,"")