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

Wishwas
  • 138
Mr. B
  • 129

3 Answers3

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.

Farhad jalehrajabi
  • 11
  • 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

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. ;-)

TheUser1024
  • 2,931
-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"

Community
  • 1
Mr. B
  • 129