Hello Harold :) yea, your reflection is right ;-) the columns are ok ! (A1 and B1).
No, i'm not using oxygen ! Now i'll try again your formula and if i can't resolve i'll send you an attachment ! p.s. anyway, why is it so hard ? If [...@] find all email ( all strings that match a dot and a @ ), why [...@] doesn't work ? The ^ in the regex it isn't " all strings that NOT match the dot and the @ " ? Thanks !! On Wed, Mar 11, 2009 at 10:52 AM, Harold Fuchs < [email protected]> wrote: > 2009/3/11 Chris Bia <[email protected]> > > > Hello Harold Fuchs ! I'm following your method, but when i arrive to > point > > 5), the result on Column C is this: > > #NAME? > > #NAME? > > #NAME? > > #NAME? > > #NAME? > > #NAME? > > > > ... > > > > For every cells ;-/ > > > > It looks to me as if you copied my formula exactly. the "A1" and "B1" in my > formula are *examples* based on my procedure which has the addresses in > Column A and you copied them into column B. If instead you used columns Q > and X then the formula would be "=IF(Q1="";X1;"")". Hmmm. On reflection I > don't think that can be the answer because your sheet almost certainly has > A1 and B1. Hmmmm. > > Perhaps you are not entering the formula correctly. The outer quotes must > *not* be entered. Apart from that I suggest you copy my formula and paste > it > into the first cell of your column C and then change the A and B as > necessary. > > Oh. Are you using OxygenOffice? There has been some discussion that in > OxygenOffice the semicolons between the parts of a Calc function should be > replaced by commas. So the formula would be "=IF(A1="",B1,"")". > > If this still doesn't work, send a sample as an attachment to your next > message. I think this list allows Calc documents as attachments. > > <snip> > > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected] >
