?
Solved

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

Posted on 2012-08-11
3
Medium Priority
?
437 Views
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.
1960s-Song-List.xlsx
0
Comment
Question by:gregfthompson
  • 2
3 Comments
 

Author Comment

by:gregfthompson
ID: 38283496
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
 
LVL 2

Accepted Solution

by:
rajshekher earned 2000 total points
ID: 38283500
Hi,

In Office 2007, Please go through given below step.

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

Your problem will be  resolved.
0
 

Author Closing Comment

by:gregfthompson
ID: 38283511
Brilliant. Thanks heaps!!!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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