Solved

CSV format - Commas not visible in saved file

Posted on 2014-04-16
10
567 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
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

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…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

772 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