1

I have a POS program that allows me to import stock items from a csv file. The problem is that it only accepts a certain csv format.

I have a Excel spreadsheet that saves my stock in different columns with applicable column headings. Even if I save that as a csv file the POS program can not import it as such. I would like to know how to convert following Excel spreadsheet (5 columns):

enter image description here

to (1 column):

enter image description here

1

Concatenation is the keyword here. You can either use the actual concatenate function, or do it using the Ampersand.

=concatenate(A1,",""",B1,""",""",C1,""",""",D1,""",""",E1,"""")

Or simply do this, which makes it easier to tell the concatenation and the inserted commas apart.

=A1&","""&B1&""","""&C1&""","""&D1&""","""&E1&""""

However, this might not be the best solution for your problem, it just answers your question. ;-)

0

Found this answer in another answer (How do you force excel to quote all columns of a CSV file?)

This page also has the solution which comes straight from the horse's mouth:

http://support.microsoft.com/kb/291296/en-us

If the link degrades, the topic to search for is:

"Procedure to export a text file with both comma and quote delimiters in Excel" and/or "Q291296"

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.