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
What I need help with is separating the data in this format.