Seperate Names on Columns

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
 
S

Sam Wilson

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

Sam
 
E

Eduardo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

seperate a full name into first, middle, last, & suffix column 1
Separate first name, middle name and last name 2
How do I do this: If A+B = D+E, make RED. 3
Return Unique Entries Only 5
first ten and last ten averages 2
Nested if's and lookup 3
Grouping data when importing to Pivot Table 1
Question on breaking on cell into three seperate 1

Top