Need to split the data of a column into different columns

Here is the data from the column:

01 Center\01.02 Center\01.02.03 Site place
01 Center\ Site 2\01.02 Center\01.02.03 Site place

I want to split this column data into two columns:

Column 1
01 Center\01.02 Center
01 Center\Site 2\01.02 Center

Column 2
01.02.03 Site place
01.02.03 Site place

I used the wizard text to column feature to split on "\" but then it gives me 4 columns and I need two columns. Is there a formula code I can use to split this or would I have to manually add the "\" to create at least 4 even columns for all the data.

Help appreciated!

some options in the file
B1=
=SUBSTITUTE(A1;"\"&C1;)
C1=
=TRIM(RIGHT(SUBSTITUTE(A1;"\";REPT(" ";99));99))

=LEFT(A3;SEARCH("\???????? Site place";A3)-1)
=MID(A3;SEARCH("\???????? Site place";A3)+1;99)

=LEFT(A5;SEARCH(" Site place";A5)-10)
=MID(A5;SEARCH(" Site place";A5)-8;99)

; could be replaced to separator according regional settings.


@AliGW usually i insert formulas in to message body.

@BMV

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.