fill cells with a value from two previous cells

[Guest]

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

 

[Guest]

Maybe this in Cell C1 and copy down........

=A1&B1

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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.

 

[Guest]

Thanks, it works well.

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.

 

[Guest]

Thanks. It works well.

Maybe this in Cell C1 and copy down........

=A1&B1

Vaya con Dios,
Chuck, CABGx3