"jul3s" wrote in
message ...

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

I hope the following is of some help.

In B1 enter the following formula
=IF(INT(ROW()/2)<ROW()/2,A2,"")
In C1 enter the following formula
=IF(INT(ROW()/2)<ROW()/2,"KEEP","DELETE")

Fill down column B and C then, while both columns are still selected, copy
then 'paste special' the values to lock them in place.

Next sort on column C and delete all the rows which contain "DELETE" in
column C.
Tidy up by deleting column C.

If you have the Analysis ToolPak installed you can use ISODD(ROW()) instead
of INT(ROW()/2)=ROW()/2