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

%3CLINGO-SUB%20id%3D%22lingo-sub-2010813%22%20slang%3D%22en-US%22%3EExcel%20is%20creating%20new%20lines%20when%20it%20finds%20a%20double%20space%20in%20a%20text%20field%20when%20importing%20a%20.csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010813%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20of%20the%20.csv%20columns%20is%20a%20text%20field%20that%20contains%20many%20spaces%20and%20characters%2C%20that%20field%20starts%20and%20ends%20with%20quote%20marks%2C%20but%20still%2C%20if%20there%20is%20a%20double%20space%20between%20the%20quotes%2C%20Excel%20takes%20it%20as%20a%20new%20line%20that%20breaks%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2010813%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

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