Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi every1
I have NINE columns showing different levels. An example: Level 1 Level 2 Level 3 Level 4 A 1 a A 2 a i A 2 a ii A 2 b i B 1 B 2 a B 2 b C 1 C 2 D E 1 Now what sort of SHORT formula should be placed in the column E (actually 10th column in the original data) which would concatinate the levels' columns resulting as follows, without using the IF() condition for placing "-" (hyphens): A - 1 - a A - 2 - a - i A - 2 - a - ii A - 2 - b - i B - 1 B - 2 - a B - 2 - b C - 1 C - 2 D E - 1 -- Best Regards, FARAZ A. QURESHI |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with concatination result. Last digit change to 0 | Excel Worksheet Functions | |||
Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
How set a format on one of more strings in a concatination | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Excal Concatination of cells that are not empty | Excel Worksheet Functions |