Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Brian Barker
At 11:28 19/02/2015 +0100, Uwe Brauer wrote: By the way, when I perform this operations for one cell say C2 and then want to enhance it to the whole column, it seems that I can only do it by dragging the boundary of the cells with the mouse. Is this correct? No. Dragging the fill handle (not

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Uwe Brauer
Brian == Brian Barker b.m.bar...@btinternet.com writes: At 18:29 18/02/2015 +0100, Uwe Brauer wrote: I run for example clean(C2) and it returns Err:522. C is the column with the problems That means that your formula is circular. I'm guessing that you have tried putting

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Manuel Andres Ramirez
El 19/02/15 a las 05:28, Uwe Brauer escribió: deletes that value to are trying to recover, it suggests that you want the value in C2 to be a CLEANed version of the value in C2 - which is a CLEANed version of what is in C2! The formula refers back to itself repeatedly, and the

Re: problem with import of excel file, cells contain new lines

2015-02-19 Thread Manuel Andres Ramirez
El 19/02/15 a las 11:18, Brian Barker escribió: At 10:53 19/02/2015 -0500, Manuel Andres Ramirez wrote: Searching a little deep. I Found that you can use [:cntrl:] in search box, to erase all non printable characters. Doesn't matter if the pattern change. Maybe this is the easy way to solution

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Uwe Brauer
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,

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Brian Barker
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

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Brian Barker
At 18:29 18/02/2015 +0100, Uwe Brauer wrote: I run for example clean(C2) and it returns Err:522. C is the column with the problems That means that your formula is circular. I'm guessing that you have tried putting =CLEAN(C2) into C2 itself. Apart from the fact that this deletes that value to

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Manuel Andres Ramirez
El 18/02/15 a las 12:56, Brian Barker escribió: 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

Re: problem with import of excel file, cells contain new lines

2015-02-18 Thread Manuel Andres Ramirez
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

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Brian Barker
At 12:00 17/02/2015 +0100, Uwe Brauer wrote: 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

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Manuel Andres Ramirez
El 17/02/15 a las 06:00, Uwe Brauer escribió: Hello 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

Re: problem with import of excel file, cells contain new lines

2015-02-17 Thread Brian Barker
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