Assuming your data starts in A1 with a header, insert a couple of rows so it
now starts in A3.

Copy the whole of Col A and paste into Col B

in C3 put =MOD(ROW(),2) and copy down as far as your data goes

Select cell B1 and do edit / delete / shift cells UP

Select the data in Col C and do data Filter / Autofilter and then filter on
0

Select all the data in Col C and do edit / go to / special / visible cells
only, and then do edit / delete / entire row.

Job done.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"jack" wrote in message
...
Hello,

I have a rather large Excel sheet in which Row 1 contains a
Name and Row 2 the Address. This continues (Odd rows
having name, even address) throughout the entire sheet.
All the information is under column A. Is there a way to
split the information so that the odd rows stay in column A
and the even rows move to Column B?

Thank you in advance,
Jack