fill cells with a value from two previous cells

  • Thread starter FormulaChallenged
  • Start date
F

FormulaChallenged

Hi,

I try to copy the letter value from column A and B to column C in the
example below with a formula:

A B C
1A A
2 I I
3...

Thanks,
FormulaChallenged
 
S

SVC

Assuming that there is a value in only column A or column B, try
=IF(A1="",B1,A1)--which means if cell A1 is blank, enter the value in cell
B1, otherwise enter the value in A1.
 
F

FormulaChallenged

Thanks, it works well.

SVC said:
Assuming that there is a value in only column A or column B, try
=IF(A1="",B1,A1)--which means if cell A1 is blank, enter the value in cell
B1, otherwise enter the value in A1.
Click to expand...
 
Top