At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote:
El 17/02/15 a las 10:06, Brian Barker escribió:
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.
Sorry, I tested with libreoffice in spanish and
use LIMPIAR() function, so I translated wrongly
as TRIM(), but now I realize that the correct function is CLEAN()
Aha! You can see that my Spanish is non-existent!
Try with CLEAN() over the Uwe attachment.
In fact I had already tried using CLEAN() without
success. I found that CLEAN() would remove the
line break but only two tab characters at a time, so something like
=CLEAN(CLEAN(CLEAN(C1)))
was necessary even to remove all five tab
characters. But that still left the space and the
final non-breaking space. Applying TRIM() did not
remove those, nor would VALUE() ignore them, so
that transpired to be a dead end.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
