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
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
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
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
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,
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
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
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
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
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
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
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
12 matches
Mail list logo