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]
