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!
Bookmarks