Hello everyone ! So, i've resolved....with Office :D Office has a filter to search and exclude particular chars with "Filter" feature.
Thanks everyone ! On Wed, Mar 11, 2009 at 1:09 PM, Harold Fuchs < [email protected]> wrote: > 2009/3/11 Chris Bia <[email protected]> > > > 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 @ " ? > > > > The expression [...@] finds every cell that contains any character that > isn't a dot or an at sign, so it probably finds every cell. > > By the way, obviously you can use any RE in step 3 depending on how > sophisticated you want to make your definition of an e-mail address (see > Brian Barker's comments). > > <snip> > > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected] >
