With your list in column A...........
Put this in B1 and copy down...it returns names only
=IF(ISERR(FIND("@",A1,1)),A1,"")
Put this in C1 and copy down...it returns emails only
=IF(ISERR(FIND("@",A1,1)),A1,"")
Copy PasteSpecial Values on Columns B and C
Then delete cell C1 moving cells in column C up one, aligning names and
emails.....

sort to remove the blank rows if desired

Vaya con Dios,
Chuck, CABGx3






"jul3s" wrote:


Hi

Just wondering if any could help me with a problem I have sorting names
and e-mails from one column.

I have an excel spreadsheet and in column A it has a list of names and
e-mail addresses. I need to split them into 2 columns emails in one
names in another for importing into another program. Is this possible?
The emails are all odd and the names even if this helps.

A B C
1. email
2. name
3. email
4. name
5. email
6. name

Thx in advance for any help.


--
jul3s
------------------------------------------------------------------------
jul3s's Profile: http://www.excelforum.com/member.php...o&userid=29516
View this thread: http://www.excelforum.com/showthread...hreadid=492171