how to import .csv to excel
 

I.m trying to import from a .csv file with 8 columns of data into an excel
spreadsheet. The positions in the .csv string have to be shuffled around a
little. For example, string position 1 needs to import to column 5 in excel.
I would be grateful for some help with the code.

Many thanks

how to import .csv to excel
 

Hi Greg,

import the .csv file, turn on macro recorder and rearange the columns.

Regards,
Ivan