Combine two columns

Question

I have two columns in excel

   A    | B
   ----------
  1     | one
  #N/A  | two
  3     | three

I want result from these two columns as:

1
two
3

Please help me to do this.

Answer 1

Put this in C1 and copy it down the C column

=IFERROR(A1,B1)