Excel is creating new lines when it finds a double space in a text field when importing a .csv

Copper Contributor

One of the .csv columns is a text field that contains many spaces and characters, that field starts and ends with quote marks, but still, if there is a double space between the quotes, Excel takes it as a new line that breaks the data.

0 Replies