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

Also you can use TEXTJOIN(...) formula (in my OFFICE 2019) for concatenating a list or range of text strings using a delimiter. It's very useful and applicable.

1
  • TEXTJOIN can be useful, sometimes. Can you show how to use it to answer this question? … … … … … … … … … … … … … … Please do not respond in comments; edit your answer to make it clearer and more complete. – G-Man Says 'Reinstate Monica' May 22 '20 at 10:26
-1

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 agree to our terms of service, privacy policy and cookie policy

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