On May 23, 6:33*am, richard Felix wrote:
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"


Something like this might also work for you.
=CONCATENATE(IF(A3=1,$A$2,),IF(B3=1,$B$2,),IF(C3=1 ,$C$2,),IF(D3=1,$D
$2,),IF(E3=1,$E$2,),IF(F3=1,$F$2,),IF(G3=1,$G$2,), IF(H3=1,$H$2,))