Solved

CSV format - Commas not visible in saved file

Posted on 2014-04-16
10
559 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 49

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 49

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 49

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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 49

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

863 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

26 Experts available now in Live!

Get 1:1 Help Now