I'm seperating out first and last names using the Text to Columns feature. However, using the space delimiter, if there are double last names that are not connected by a hyphen, it gives me a completely new column. Is there a way to keep the 2nd last name in the same column as the first last name without concatenating the 2 last name columns together again?
Thanks!