If I have a several people's full name in one column(in the format below), how can I split their name into one column with their first name and a second column with their last name?
Ex:
Doe, John
Doe, Jane
Johns, Bob
Jones, Ralph
Smith, Joe
If I have a several people's full name in one column(in the format below), how can I split their name into one column with their first name and a second column with their last name?
Ex:
Doe, John
Doe, Jane
Johns, Bob
Jones, Ralph
Smith, Joe
Go to "Data", "Text to columns" and choose "coma delimited.
or
In cell B1:
and in cell C1:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Portuga; 04-02-2008 at 03:57 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks