Data truncation while performing text to columns for a CSV file

Occasional Visitor



I have a CSV file with semicolon  as delimiter which is huge event log downloaded from UPS. There are 169 datas seperated using semicolon in one cell which I need to seperate to 169 different column cells. But while I perform the same the data getting truncated and one 1st 6 column data is only getting populated in different cells. Please help.

1 Reply

@yasinji Did you just double-click on the CSV to open it? If so, try to import it via the Data ribbon, From Text/CSV.