In cell B1 copy the formula and copy that down... this will pick only the
values in A2,A4 ... Once done. copy ColB. Right Click. Paste Special and OK
there itself.

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


If this post helps click Yes
---------------
Jacob Skaria


"Yuelin" wrote:

Hi

I have values in a column of cells, A1, A2, A3, A4, A5, A6, A7, A8 and so on.

Then I only want to pick up the value in A2, A4, A6, A8...., and put them
into column B, i.e. B1, B2, B3, B4....

How to do this

Thanks

Yuelin