Seperate Names on Columns
 

I have column that contain names both first and last name. I want to break
this to different column that will seperate First name on its own column and
last name on another column without re-typing them.

For example A
A1 NAMES
A2 Adanni, KIm
A3 Adams, Luke
A4 Angela, Murphy.

Now I WANT
A B
First Name Last name
Adanni Kim
Adams Luke
Angela Murphy
This is a very long list names. Too much to retype them. I want to just
seperate automatic

Seperate Names on Columns
 

Select the entire column and go to data/text to columns. Choose delimited,
and make comma your delimiter.

Sam

"Kanmi" wrote:

I have column that contain names both first and last name. I want to break
this to different column that will seperate First name on its own column and
last name on another column without re-typing them.

For example A
A1 NAMES
A2 Adanni, KIm
A3 Adams, Luke
A4 Angela, Murphy.

Now I WANT
A B
First Name Last name
Adanni Kim
Adams Luke
Angela Murphy
This is a very long list names. Too much to retype them. I want to just
seperate automatic

Seperate Names on Columns
 

Hi,
Highlight the column, go to Text to columns, delimiters, choose comma, next
next

"Kanmi" wrote:

I have column that contain names both first and last name. I want to break
this to different column that will seperate First name on its own column and
last name on another column without re-typing them.

For example A
A1 NAMES
A2 Adanni, KIm
A3 Adams, Luke
A4 Angela, Murphy.

Now I WANT
A B
First Name Last name
Adanni Kim
Adams Luke
Angela Murphy
This is a very long list names. Too much to retype them. I want to just
seperate automatic

Seperate Names on Columns
 

DataText to ColumnsDelimiterComma...
--
If this post helps click Yes
---------------
Jacob Skaria


"Kanmi" wrote:

I have column that contain names both first and last name. I want to break
this to different column that will seperate First name on its own column and
last name on another column without re-typing them.

For example A
A1 NAMES
A2 Adanni, KIm
A3 Adams, Luke
A4 Angela, Murphy.

Now I WANT
A B
First Name Last name
Adanni Kim
Adams Luke
Angela Murphy
This is a very long list names. Too much to retype them. I want to just
seperate automatic