How to create a single line separated by commas from a matrix?

[Alex]

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.

 

[Don Guillett]

try this idea for a formula
=""""&E1&""""&","&""""&F1&""""

 

[Thomas Hardy]

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"