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

Posted on 2012-08-11
Last Modified: 2012-08-11
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.
Question by:gregfthompson

    Author Comment

    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.
    LVL 2

    Accepted Solution


    In Office 2007, Please go through given below step.

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

    Your problem will be  resolved.

    Author Closing Comment

    Brilliant. Thanks heaps!!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now