How would I filter a copied AOL Address Book pasted into excel? I want it to
be three columns (first name, last name, email address). Has anybody ever
done this before? I have to get it into this format because I'm transferring
into a site called Constant Contact for email newsletters.

How exactly is the current format? Give examples.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111091

It's in this format:

None
Screen Name: Mmarunczak

It repeats in that order.

"NBVC" wrote:


How exactly is the current format? Give examples.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111091

I don't see first name, last name and email to extract


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111091

In some of them, in place of none is first, last name
and in place of screename (AOL email) is an email address

"NBVC" wrote:


I don't see first name, last name and email to extract


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111091

I think you need to give examples of all possible combinations and
indicate if they are in the same cell, two cells, etc...


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111091