>> "Manuel" == Manuel Andres Ramirez <manuelandr...@aim.com> writes:

   > 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.
   >> 

Thanks but.

I run for example clean(C2) and it returns Err:522

C is the column with the problems

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to