Seperate email addresses?

  • Thread starter Thread starter Jim K
  • Start date Start date
J

Jim K

I have imported a list of names, addresses, email
addresses, etc. into Excell. I've gotten each item into a
seperate cell in a single column. All I want in my final
list is the email addresses and can't figure out how to
do it. The only common denominator that I can see is the
@. Any help is appreciated. In now looks like this:

John Doe
123 Anystreet
(e-mail address removed)
mary smith
321 Pine
(e-mail address removed)
 
Jim said:
I have imported a list of names, addresses, email
addresses, etc. into Excell. I've gotten each item into a
seperate cell in a single column. All I want in my final
list is the email addresses and can't figure out how to
do it. The only common denominator that I can see is the
@. Any help is appreciated. In now looks like this:

John Doe
123 Anystreet
(e-mail address removed)
mary smith
321 Pine
(e-mail address removed)
Click to expand...

Hi Jim
one way: in cell B1 add the following formula:
=IF(ISERROR(FIND("@",A1)),"no email", "email")
copy this down. Afterwards filter this column. e.g. show all 'no email'
rows and delete them

Frank
 
-----Original Message-----


Hi Jim
one way: in cell B1 add the following formula:
=IF(ISERROR(FIND("@",A1)),"no email", "email")
copy this down. Afterwards filter this column. e.g. show all 'no email'
rows and delete them

Frank

.
Frank, your solution worked perfectly. Thank You !!!
Click to expand...
 
Back
Top