Solved

CSV format - Commas not visible in saved file

Posted on 2014-04-16
10
592 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
[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
  • 5
  • 4
10 Comments
 
LVL 51

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 51

Expert Comment

by:Rgonzo1971
ID: 40003593
Could you attach a dummy xls example?
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
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 51

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
 
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 51

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

729 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