Need help with CSV to XLS - tried everything. Peculiar issue

asked 2018-11-01 17:54:51 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have tried text to column etc. It seems the issue is with the last column - the value that should be in the last column goes onto the next row which when converted messes everything and you sit with the last column's value sitting under the first column. Please help!

edit retag flag offensive close merge delete

Comments

What exactly are you doing? What does the data look like? Are you by chance trying to import CSV data? That by chance in its second-but-last column contains an embedded newline? And the filed content is not quoted? Please see also the guidelines for asking.

erAck gravatar imageerAck ( 2018-11-01 18:13:31 +0200 )edit

Oh and btw please don't mark the question as wiki next time. Thanks.

erAck gravatar imageerAck ( 2018-11-01 18:14:18 +0200 )edit