So you might need to user a macro unless there is a string replacement method.... Does calc support find and replace for these characters... Perhaps with a regular expression.
On Feb 17, 2015 10:06 AM, Brian Barker <b.m.bar...@btinternet.com> wrote: > > At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote: > >El 17/02/15 a las 06:00, Uwe Brauer escribió: > >>I periodically receive excel files (generated > >>by Office 2010 I think, but saved in the old > >>binary format). Some of these columns cause me > >>problems, since they seem to contain spaces and > >>even newlines. I could correct that manually, > >>but since the file contains hundred of lines > >>this is cumbersome. So the question is whether > >>there exist any formatting function which could resolve the issue. > > > >You can use TRIM() or LIMPIAR() "in spanish" > >function over the column C and correct the spaces or tabs. > > I tried TRIM(), but this seemed to do nothing in > this case. It would not remove the tabs or line > breaks or non-breaking spaces; it could remove > the ordinary spaces, but only when they were > trailing - so only if the non-breaking spaces had already been removed. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >