Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • August 30, 2004 at 9:25 am in reply to: export to csv –want separate columns #16235
    1kyle
    Member

    Found the answer.

    1) Export your data as CSV

    2) instead of opening EXCEL direct rename the file to a .TXT file.

    3) Open the file in excel as a TXT file.

    4) Excel will then prompt saying This is a delimited file etc.

    5) Chose the delimited option

    6) He Voila — your data is in nice columns.

    Cheers

    everbody

    -K

  • Author
    Posts
Viewing 1 post (of 1 total)