Solved

CSV format - Commas not visible in saved file

Posted on 2014-04-16
10
554 Views
Last Modified: 2014-04-16
Hi xperts

I've been hoping to obtain a file delimited by commas as a CSV file from an Excel spreadsheet. Although the file gets created there are no commas in sight. I have tried saving in both formats for CSV offered in the dropdown.

Am I missing something? Thanks if you can clarify.
0
Comment
Question by:krakatoa
  • 5
  • 4
10 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40003569
Hi,

With which application did you reopen the file?

Regards
0
 
LVL 16

Author Comment

by:krakatoa
ID: 40003587
Notepad. But I also tried 'typing' it to console output with DOS.
0
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40003593
Could you attach a dummy xls example?
0
 
LVL 16

Author Comment

by:krakatoa
ID: 40003595
You mean a spreadsheet?

I've got Excel 2000. Not sure an attachment will show us much. All I have is values 1 to 10 in col A, then saved as csv. The file icon clearly then says Excel .csv format, but as said - no commas.
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40003600
If you have nothing in col B and further, you will not see any comma

Regards
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 16

Author Comment

by:krakatoa
ID: 40003630
Holy smoke. I would never have discovered that. You are right - many thanks indeed.

However the reason I needed it was to get email addresses (which were supplied to me in a single-column spreadsheet) into web Outlook. Outlook failed, complaining that the format was incorrect - (due to the missing commas). But now I am not sure what Outlook is going to make of a second column, with data in it that will not be relevant to the email addresses. Do you have any ideas about this?

Maybe I need to split the addresses over two columns. Artificial, but it could work possibly?
0
 
LVL 19

Expert Comment

by:helpfinder
ID: 40003650
to split cell to two or more you can use some formula or more handy would be Text To Columns feature in Excel (if there is some separator you can use - like space, or some character)
If you ca attach some sample, just one row for example me or some other expert can check
0
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40003662
Hi,

You could transpose the data if the number of rows  of your data is less than the columns of aour excel

Copy Paste Special  and Tick Transpose

or in Cell B2 you could enter this formula

=B1&","&A1

Open in new window

and then fill down

and use the last cell for your mail

Regards
0
 
LVL 16

Author Comment

by:krakatoa
ID: 40003846
Cool. Thanks.
0
 
LVL 16

Author Comment

by:krakatoa
ID: 40003879
Actually, the easiest way I decided on was just to cut and paste about half of column A into col B, and then do a CSV save. But great, thanks again.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

760 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

18 Experts available now in Live!

Get 1:1 Help Now