Results 1 to 3 of 3

Thread: SendTo Excel Doesnt Recognise Commas [RESOLVED]

  1. #1

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383

    SendTo Excel Doesnt Recognise Commas [RESOLVED]

    My program outputs a comma delimited file which I subsequently analyse using Excel.
    If I open the file from within Excel, the commas are recognised by the Text Import
    Wizard and the data is input into cells.

    However, if I open the file using my SendTo link to Excel, the file opens as text in one column.

    Any ideas to this? How to fix it?
    Attached Files Attached Files

  2. #2
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611
    There is an option under the DATA menu, Text to columns (I don't know if it is excactly called like that, I have a dutch version from office at work), that does the trick
    VB6 & C# (WCF LINQ) mostly


    If you need help with a WPF/WCF question post in the NEW WPF & WCF forum and we will try help the best we can

    My site

    My blog, couding troubles and solutions

    Free online tools

  3. #3

    Thread Starter
    Frenzied Member agmorgan's Avatar
    Join Date
    Dec 2000
    Location
    Lurking
    Posts
    1,383
    Nice workaround
    I think thats the best Im going to get.

    Thanks.

Posting Permissions

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



Click Here to Expand Forum to Full Width