It appears that the actual contents of Field2 = 05329954A\n where '\n' is a RETURN (not a TAB). I was able to remove the \n by (1) select/highlight the column containing Field2, (2) open Data > Text to Columns, (3) Under 'Separator Options' set Y=Separated by, Y=Other as \n then click 'OK'. Now save as CSV.
On Wed, Jun 21, 2017 at 8:52 AM, Uwe Brauer <o...@mat.ucm.es> wrote: > > Hi > > I have an excel (xls) file which I open with scalc (5.3) > and save it as csv > > Unfortunately it looks like > > Field1,Field2,Field3,Field4,Field5 > "Name","05329954A > ",0.55,0.75,1.3 > > Instead of > > Field1,Field2,Field3,Field4,Field5 > "Name","05329954A ",0.55,0.75,1.3 > > > The reason is that in the first column there is a after name a space > which is translated to a newline when exporting. > > How can I get rid of this unwanted newline? > I tried to format the cells but it seemed not to have worked. > Thanks > > Uwe Brauer > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted