![]() |
Delimiters in Text to Columns
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! |
All times are GMT +1. The time now is 12:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com