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]
