Spilt into two columns

[GARCIAJ8]

I am trying to split the data into two columns. I used the "Text To Columns" to separate the data, but it still didn't work. 

Data: "00012-34543 - ABCD EFG"

When I used the "Text To Column" to split with delimiters being "-" the result was

00012

34543 - ABCD EFG

What I need help with is separating the data in this format. 

00012-34543

ABCD EFG

[flying008]

Hi,@GARCIAJ8 

Because your have 2 spaces around in the second '-', so you maybe need regex tool to split that to 2 columns.

Thus, if you have many group to be split by ' - ', you can replace it by '|' , then use Text to Column tool to do it.

[Qiu · Accepted solution]

@GARCIAJ8 
Just want to add the RegEx based on the work of @flying008 .