Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine
hi,
i have a sheet in which there are multiple (2 or 3) rows for some values. the only difference between these rows is the values in columns C, D and E. for example cell A1 = "dog". cells C1, D1 and E1 are different for rows 2 and 3. i would like to know how i can combine these rows into one so that we have a concatenation of the rows/columns C, D and E for each entity. thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combine
Hi Try
="A1"&"c1"&"d1"&"e1" "geebee" wrote: hi, i have a sheet in which there are multiple (2 or 3) rows for some values. the only difference between these rows is the values in columns C, D and E. for example cell A1 = "dog". cells C1, D1 and E1 are different for rows 2 and 3. i would like to know how i can combine these rows into one so that we have a concatenation of the rows/columns C, D and E for each entity. thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is IF the right way to combine these? | Excel Worksheet Functions | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
how to combine........ | Excel Discussion (Misc queries) | |||
Combine into one please. | Excel Worksheet Functions |