I have a column of information, in 1 worksheet, that has name data that literally looks like this:
JohnSmith - Owner
The first and last names are not separated by anything, only showing up as different words because of capitalization. The "Job Title" in this column is separated by a space...