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

Mail Merge Help 1
Grouping Names in Mail Merge 0
Drop down lists in seperate columns 5
Separate first name, middle name and last name 2
Track Changes 0
seperate a full name into first, middle, last, & suffix column 1
Find Duplicate names listed in opposite order 1
Two columns followed by single page-width column on same page 0

Top