Split column based on first occurrence of the delimiter "-"

[wiki.horizon]

Hi,

I need to split column C into 2 columns based on the first occurrence of "-".

Kindly let me know how to do the same.

Regards,
wiki.horizon

 

[VoG]

Try like this

Excel Workbook
	C	D	E
1	left-right-part	left	right-part
Sheet1

 

[wiki.horizon]

Hi,

I tried using the given formula but the result is #Value.

Please let me know how to rectify it.

Regards,
wiki.horizon

 

[VoG]

Can you post some examples of what you have in column C.