In the solution, there does not seem to be a graceful way to deal with separating the company and slogan. For example, one record is "Kerluke West - leverage cross-media users."
The text-to-column used in the solution (using "-'' as the delimiter and splitting into two columns) separates it as the following: "Kerluke" and "West-leverage cross-media users."
As the correct output should be "Kerluke West" and "leverage cross-media users", does anyone know a solution for achieving this?
In the long run, none of the rows that are in the final solution have to worry about this problem, but technically behind the scenes, the text-to-column tool does not work flawlessly.
