Seperate Names on Columns

  • Thread starter Thread starter Kanmi
  • Start date Start date
K

Kanmi

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
 
Select the entire column and go to data/text to columns. Choose delimited,
and make comma your delimiter.

Sam
 
Back
Top