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: [email protected]
For additional commands, e-mail: [email protected]
