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 ;-/ On Mon, Mar 9, 2009 at 8:59 PM, Harold Fuchs <[email protected] > wrote: > On 09/03/2009 14:12, Chris Bia wrote: > >> Hello Brian ! >> >> Mmm, i need something of very very very simple because i've a lot of cells >> of this: >> >> [email protected] (correct) >> hotmail (not correct, so i must eliminate) >> ma...@hotmail (not correct, so i must eliminate) >> >> So, i'm triyng to find the cells that not contain a "dot" or a "@" >> >> >> > This might work for you > > 1. Copy the column containing the data, say copy column A to column B > 2. Select the column but *not* the copy > 3. Find, *within the current selection* cells containing . or @ (reg > exp is [...@]) > 4. Delete those cells, leaving the errors > 5. In a new column, say C, enter the formula "=IF(A1="";B1;"")" > > Column C now has addresses where A has addresses and nulls elsewhere. > > > -- > Harold Fuchs > London, England > Please reply *only* to [email protected] > >
