For the odd numbered rows enter this formula in B1:

=INDEX(A:A,ROWS(B$1:B1)*2-1)

For the even numbered rows enter this formula in C1:

=INDEX(A:A,ROWS(C$1:C1)*2)

Select both B1 and C1 and copy down as needed.


--
Biff
Microsoft Excel MVP


"Stu Pidaso" <Stu wrote in message
...
Okay. I had someone show me what to do (on office 2003 I think) but I
cannot
get it to work on 2007. I have a list I am trying to split with every
other
number, odd and even. The list in column A is about 460 words. In column
B,
I was shown to do this....

cell B1 =$A1
cell B2 =$A3

He then used the CTRL key to select both cells and then drag down. What
this
did was a continuation of the odd numbers but let A appear before each
number. When I use the CTRL key in Office 2007 and select both cells, I do
not get the dark outline with the black dot at the bottom right that is
supposed to be used from grabbing and dragging. I have alos tried the
shift
key which seems to select both but when dragging down does not do what
this
person had shown me.