Copy non adjacent cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a column of data thus
A
1 12345
2
3 23232
4
5 26552

What I need to do is copy the data in cell A1 to cell A2, the data in A3 into A4 etc,

How is this done

Alby
 
Select the range, press F5, click special, select blanks.
type equal sign, press up-arrow, press ctrl + enter
 
Back
Top