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