+ Reply to Thread
Results 1 to 3 of 3

CSV problem

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    Mor, Hungary
    MS-Off Ver
    Excel 2007
    Posts
    2

    CSV problem

    Hello,

    I have a very basic (me thinks) and annoying problem with converting an Excel spreadsheet into a CSV file.
    Basically need to convert a file with 3 columns into a CSV file, to be in a single column and be separated by commas.

    I have done this several times with Excel 2007 and it worked ok.
    Please see attached files.
    Inventur_right.csv
    Inventur_wrong.csv

    What am I doing wrong?

    Thanks,
    Steve

  2. #2
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Re: CSV problem

    Write the following forumula

    =CONCATENATE(A2,",",B2,"',",C2)

  3. #3
    Registered User
    Join Date
    01-23-2013
    Location
    Mor, Hungary
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: CSV problem

    I know, I did that already, but I have to rewrite some work instructions if we can't do it as simply as with the old version of excel.
    Thanks, though!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1