Page 1 of 1
[Solved] Split to first and last name columns
Posted: Fri Feb 26, 2021 5:42 pm
by Saxplayerz
I have a sheet that contains the first and last name in one case column and I would like to separate it into a first name column and a last name column. However there are a few names that are business entries as single words and a few that are listed like “Bob & Jane Smith “. How can I did that?
Re: Split to first and last name columns
Posted: Fri Feb 26, 2021 8:28 pm
by RusselB
Welcome to the Forums.
You can start by using Data -> Text to Columns and use the space character as the separator. This should give you the split you want for most of the entries.
There will still be some that you'll have to edit manually, such as the "Bob & Jane Smith"
This is probably the easiest method.
An alternative is to find the location of the last space character and then generate a First name column going up to that character and a Last name column going from that character to the end of the string.