Jack

Put this formula in B1 and copy down.

=IF(MOD(ROW(A1),2)=1,OFFSET(A1,1,0),"")

Copy the formulae in column B and editpaste special...values back over
itself to 'kill' the formulae

You can then filter the column B by blanks (DataFilterautofilter) and
delete the filtered rows.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"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