Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional concatenation and commas
I have several rows & cols in a spreadsheet that I need to concatenate
the columns for. The source is: A1 = Name1 B1 = 2 C1= 3 A2 = Name2 B2 = C1 = 5 A3 = Name3 B2 = 1 C1 = A4 = Name4 B2 = 3 C1 = 2 The result would look like: A1 = Name1 D1 = 2,3 (the concatenation of B1 & C1) A2 = Name2 D1 = 5 A3 = Name3 D1 = 1 A4 = Name4 D1 = 3,2 Where there are 2 numbers, I want to include a comma, but where there is one number I do not want to include a comma. Any help appreciated. BC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation | Excel Discussion (Misc queries) | |||
So many commas | Excel Worksheet Functions | |||
Conditional concatenation? | Excel Worksheet Functions | |||
Concatenation Help | Excel Worksheet Functions |