Split records separated by a comma, in one column list into two columns

The lists contains a  a column of records where the record in each cell is several words followed by a comma a space and then several more words.
1960s-Song-List.xlsx
gregfthompsonAsked:
Who is Participating?
 
rajshekherConnect With a Mentor Commented:
Hi,

In Office 2007, Please go through given below step.

Data Tab --> Text to Columns --> Delimiters --> Select Comma.

Your problem will be  resolved.
0
 
gregfthompsonAuthor Commented:
The lists is of song titles and artists.  i.e.  Song Title, Artist Name    

I'm seeking to have the list split to have the song title in one column and the artist in the adjacent column.
0
 
gregfthompsonAuthor Commented:
Brilliant. Thanks heaps!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.