Column delimiter in Excel?

Printable View

11-25-2010
trillykins

Column delimiter in Excel?

Perhaps an odd question, but I am trying to get my .csv output be separated by columns, and I thought this would be done be a simple Tab ( /t ), but that just leaves a strange ? sign instead and everything will be lumped into the same column.

The spaces are separated with Tab...

Code:

A B C D 0,0 -0,0 23,8 23,0 0,5 -0,0 23,8 23,0 1,0 -0,0 23,7 23,0

This is how I am trying to make the output look and I can't find any information on how I can accomplish this. Does anyone have any ideas? Thanks in advance!
11-25-2010
Bayint Naung

Where's the code?
11-25-2010
Dino

What file type are you using to store your output data.

IIRC, I think you can tell Excel what the field delimiters are when importing your data.
...
Yes, I am correct: How to Import a Delimited File into Excel | eHow.com
11-25-2010
trillykins

Quote:

Originally Posted by Dino

What file type are you using to store your output data.

IIRC, I think you can tell Excel what the field delimiters are when importing your data.
...
Yes, I am correct: How to Import a Delimited File into Excel | eHow.com

I just use a .csv filetype to store my output, but I am guessing that I should use .txt and then import it. Thought there was some universal column delimiter for the .csv filetype.
11-25-2010
Dino

Commas and semicolons are the two common default separators for a .csv file.
Comma-separated values - Wikipedia, the free encyclopedia
11-25-2010
KBriggs

tab is \t not /t