| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| color fill cells based on IF function or formula | Excel Worksheet Functions | |||
| blank cells with auto fill in excel | Excel Worksheet Functions | |||
| FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
| How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
