Brian Barker keyed the following on 7/12/2007 11:56 PM:
At 23:21 12/07/2007 -0400, Peter Abbott wrote:
I have a file of email addresses, one per line.
I thought that if I changed the file type to CSV and open it with
scalc, I could somehow filter out the ones with hotmail.com and
msn.com,
Hi Peter,
The most straightforward way to do what you want is to open the csv file
and import all of it. Fill an empty column with the formula
=IF(AND(ISERROR(FIND(msn.com;A1));ISERROR(FIND(hotmail.com;A1)));NOT;Flag)
This is assuming that the addresses are in column A. Adjust the formula
if
Anthony Chilco keyed the following on 7/13/2007 5:26 PM:
Hi Peter,
The most straightforward way to do what you want is to open the csv file
and import all of it. Fill an empty column with the formula
=IF(AND(ISERROR(FIND(msn.com;A1));ISERROR(FIND(hotmail.com;A1)));NOT;Flag)
This is
On Fri, 13 Jul 2007 20:02:59 -0400
Peter Abbott wrote:
Anthony Chilco keyed the following on 7/13/2007 5:26 PM:
Hi Peter,
The most straightforward way to do what you want is to open the csv
file and import all of it. Fill an empty column with the formula
I have a file of email addresses, one per line.
I thought that if I changed the file type to CSV and open it with scalc,
I could somehow filter out the ones with hotmail.com and msn.com, but I
haven't been able to configure the filter to do this.
Can anyone help? Thanks.
At 23:21 12/07/2007 -0400, Peter Abbott wrote:
I have a file of email addresses, one per line.
I thought that if I changed the file type to CSV and open it with scalc,
I could somehow filter out the ones with hotmail.com and msn.com, but I
haven't been able to configure the filter to do this.