How do I extract data from every other cell in a colomn?
I have a long colomn of data that i pasted from the web. I want to get the
data from every other cell. (i.e. A2, A4, A6, A8, A10 . . . ECT) I want to
write a formula that will will take that sequence and then let me autofil and
continue the sequence. How do I do that? For the life of me I can not
figure it out.
I would be most grateful if you could help me!
Spencer
|