title: Excel If cell is empty want to move data from another cell
body: <p>I wish to check if a cell in say column A  is empty and if it is then move the data from the next column B into it.  Else nothing done.
  I wish it to check 1500 rows. I tried</p>
  
  <p>If(A2="",A2=B2,"")  I thought I could just copy it down the column.  I get a circular error reference and also then cellA2 changes to 0.
  Thank you for your help.</p>