software

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
Maybe this in Cell C1 and copy down........

=A1amp;B1

Vaya con Dios,
Chuck, CABGx3
quot;FormulaChallengedquot; wrote:

gt; Hi,
gt;
gt; I try to copy the letter value from column A and B to column C in the
gt; example below with a formula:
gt;
gt; A B C
gt; 1A A
gt; 2 I I
gt; 3...
gt;
gt; Thanks,
gt; FormulaChallenged
gt;
gt;

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

quot;FormulaChallengedquot; wrote:

gt; Hi,
gt;
gt; I try to copy the letter value from column A and B to column C in the
gt; example below with a formula:
gt;
gt; A B C
gt; 1A A
gt; 2 I I
gt; 3...
gt;
gt; Thanks,
gt; FormulaChallenged
gt;
gt;

Thanks. It works well.

quot;CLRquot; wrote:

gt; Maybe this in Cell C1 and copy down........
gt;
gt; =A1amp;B1
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;FormulaChallengedquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I try to copy the letter value from column A and B to column C in the
gt; gt; example below with a formula:
gt; gt;
gt; gt; A B C
gt; gt; 1A A
gt; gt; 2 I I
gt; gt; 3...
gt; gt;
gt; gt; Thanks,
gt; gt; FormulaChallenged
gt; gt;
gt; gt;

Thanks, it works well.

quot;SVCquot; wrote:

gt; Assuming that there is a value in only column A or column B, try
gt; =IF(A1=quot;quot;,B1,A1)--which means if cell A1 is blank, enter the value in cell
gt; B1, otherwise enter the value in A1.
gt;
gt; quot;FormulaChallengedquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I try to copy the letter value from column A and B to column C in the
gt; gt; example below with a formula:
gt; gt;
gt; gt; A B C
gt; gt; 1A A
gt; gt; 2 I I
gt; gt; 3...
gt; gt;
gt; gt; Thanks,
gt; gt; FormulaChallenged
gt; gt;
gt; gt;