Forum Discussion
Split data from one column into two columns
I have a large database where the first and last names are in one column. I need to have them in separate columns. Is there a way to separate the names without having to cut and paste?
Thanks.
Hi Jonni,
This is the best technique to split any column based on a delimiter (Space, Comma...)
6 Replies
Hi Jonni,
This is the best technique to split any column based on a delimiter (Space, Comma...)
Thanks, Haythem!
But that only works if the first name and last name in every case are exactly the same length, as they are in your example. My database is composed of names of different lengths.
I tried your method, and wound up with some names being truncated, and in others part of the last name remained in the firstname column.
Jonni
Hi Jonni,
Could you please provide us with a sample of your database to diagnose it and to provide you with the perfect solution?
