How to create a single line separated by commas from a mat..

Alex,

It looks as though you need to create a CSV file (comma separated values).
You can save an Excel spreadsheet directly in this format by selecting File,
Save As and then selecting file type CSV(Comma delimeted)(*.csv).

The problem here is that Excel will only put the quotation marks around
cells where a comma is included in the text. However, I would suggest that
you give this a try since the CSV format is a fairly standard way to
transfer data between different applications so your system may accept the
format.

I can't find a way to force the quotes during the Excel save, but if you
move your data from the spreadsheet to an Access table, you can export the
data into a file with precisely the file format you require with no
additional data manipulation. Here is an example I prepared on my pc:

"Char1","Char2","Char3"
"Name","Street","Town"



"Alex" schrieb im Newsbeitrag

> Hello,
>
> I've the following problem.
>
> I've a table made of several columns. Each colum represents a
> characteristic regarding to a subject (e.g. Name, Surname, Home
> Street, etc...). In the rows I put the different people.
>
> I need to export these info to a format compatible with other program -
> an email program-, which requires the information to be arranged in a
> different way. The program needs all these data to be ordered in a
> single row, with each characteristic between quotation marks, and
> separated by commas, following this pattern:
>
> "characteristic 1","characteristic 2","characteristic 3"...
>
> Also, the order of the different "characteristics" in the single row
> doesn't have to match with the order of my table.
>
> Could you suggest me any idea about how to deal with this?
>
> Thank you.
 >> Stay informed about: How to create a single line separated by commas from a mat..