I am trying to split a character in a column New Brunswick NJ into two different columns. I used Text to Column. However, i used the "space" as the delimiter and it separated the text into two columns as New Brunswick NJ I would like the output to read New Brunswick NJ in two separate columns. Thanks in advance
Solved! Go to Solution.