Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate for multiple columns
1st Row : Anand ](Cell1) is(Cell2) a(Cell3) good boy. He Smokes Often.
2nd Row: 1 1 0 1 1 0 1 1 3rd Row : 1 1 1 1 1 1 1 0 The each word in the sentence is split for each cells. Below each cell there is boolean values ( 1's and 0's). Problem : I want to concatenate the words(Row1) for words having values 1. then the output should be. 2nd Row Output: "Anand is good boy smokes often" 3rd Row Output: " Anand is a good boy he smokes" 1. if multicat how to customize the function Thanks in advance. Regards Richard. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining columns and using concatenate | Excel Worksheet Functions | |||
CONCATENATE TWO COLUMNS | Excel Worksheet Functions | |||
Concatenate multiple rows and columns into 1 cell | Excel Discussion (Misc queries) | |||
Concatenate Four Columns With Seperators | Excel Discussion (Misc queries) | |||
Concatenate two columns? | Excel Worksheet Functions |