Solved

separating each data by column its full of comas

Posted on 2014-04-08
6
202 Views
Last Modified: 2014-04-16
hello

When I export the registrant list from a program my computer does not recognize that it’s a CSV file so it opens up and excel and instead of separating each data by column its full of comas and very hard to read file.

I tried it on other pc and it worked fine. So something to do with my settings on PC.  Any idea.
0
Comment
Question by:koila
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 1

Expert Comment

by:Christopher Gay
ID: 39987002
Depending on which version of Excel you are using will change exactly where the option is. Under the Data tab in a black spreadsheet select the existing data from text option and then select the delimiter as commas or whatever your CSV file is using specifically. That should resolve your issue on that machine.
0
 
LVL 4

Author Comment

by:koila
ID: 39987056
2010, please advise.
0
 
LVL 4

Author Comment

by:koila
ID: 39987064
I didn't understand,

select the existing data from text option and then select the delimiter as commas

I'm using comma.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 4

Author Comment

by:koila
ID: 39987071
here is my file.
regi.csv
0
 
LVL 1

Accepted Solution

by:
Christopher Gay earned 500 total points
ID: 39987088
Try this:
1. Open the File in Excel.
2. Go to the Data tab.
3. Highlight the two columsn
4. Choose the Text-To-Columns option.
5. Select delimiter as the option and hit next.
6. Choose the comma as the delimiter option and unselect the tab option.
7. Click finish.
0
 
LVL 4

Author Closing Comment

by:koila
ID: 40004944
tx
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
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 demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

628 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