Software

Ask something
Discussion Locked

Splitting cell infor into two columns

0 helpful
1 reply

by gslywchuk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to split a Contact name cell, which contains first and last name, into two, so that you can then have First Name, Last Name?

1 reply

by dklippert

Yes! Depending on how they're separated.
One way is to insert some blank columns to the right of the names. Select the name row and go to Data>Text to Columns. You can choose a space or comma or any other character.
This will split the names up, but then you may have to clean up extra spaces.

For a complete discussion and some great functions, look at Chip Pearson?s site:

WWW.CPearson.com/excel/FirstLast.htm

This discussion is closed to new replies.