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

Improve this question

3 Answers 3

Reset to default
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. ;-)

Improve this answer
1

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.

Improve this answer
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'
    Commented May 22, 2020 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"

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .