Write to spreadsheet in separate cells

[MarkGreally]

Hi Folks.

In the VI attached I am writing the time and amplitude of the signal to a spreadsheet. The problem is that they are in the same cell. I have used a tab delimiter but that will not seperate them. The rows are fine but I would like two colomns for time and amplitude. As you can see below they are in the same cell. How can I seperate them?

0.000000 0.068000

0.002000 0.068000

0.004000 0.072000

0.006000 0.068000

0.008000 0.068000

Thanks,

Mark.

[adambro · Accepted solution]

I think that works, it may just be how you are opening the file. If you open that in Excel, because it has a CSV extension, it will be treated as having comma delimiters and so you will see everything in one cell. If you give it a TXT extension then open that in Excel, it will treat it as tab delimited and open correctly.

[MarkGreally]

Cheers that worked.