fill cells with a value from two previous cells
 

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

fill cells with a value from two previous cells
 

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

=A1&B1

Vaya con Dios,
Chuck, CABGx3



"FormulaChallenged" wrote:

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

fill cells with a value from two previous cells
 

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.

"FormulaChallenged" wrote:

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

fill cells with a value from two previous cells
 

Thanks. It works well.

"CLR" wrote:

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

=A1&B1

Vaya con Dios,
Chuck, CABGx3



"FormulaChallenged" wrote:

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

fill cells with a value from two previous cells
 

Thanks, it works well.

"SVC" wrote:

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.

"FormulaChallenged" wrote:

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