Convert CSV TXT in separate columns.

[tono68]

Hi, I’m new on the forum and has searched the past days to some info about splitting/ converting text string, from a CSV file produced by a datalogger, into separate columns. I found a VBA/macro from WAMP dated 4-20-2010 (Programmatically convert comma separated text to Columns) as one what does the separation and I partly understood the code. As result the separated TXT was reproduced into Rows. Although some modifications I couldn’t achieve to get it into columns. Can somebody explain me the code line:

Selection.Rows(i).Resize(UBound(splitValues) - LBound(splitValues) + 1).Value = Application.Transpose(splitValues)

And how to change this one to achieve the result into columns. ( changing Selection.Rows(i) into columns has no effect).

Attached a (part) example of the datalogger file, an example of the desired output and the above mentioned VBA/ macro.

I did a lot of Google searches and found that in more than 90% the solutions delivered the output result into separate rows. This gave me the idea that separation into columns is somewhat special.

I’m looking for a VBA/macro solution because the the datalogger produces daily a file with a lot of TXT lines.

Thanks in advance for some help and guidance.

[AndyLitch]

Excel should open .CSV files and automatically split the comma separated values into different columns...But the data/headers have to start on row 1.

This will obviously create problems with your dates and times but that can be easily remedied.

[tono68]

Thanks for the response. As far I have expierenced above suggestion is not applicable to Excel2003 or the CSV files structure from the datalogger are different. Have in the mean time found the solutions ( found and modified 2 macro's combined ).