hi all
in my test excel file, on the source column there have lots of name are available. now i want to combined them all in 2 or 3 or 10 words in a cell like the result column, is it possible?
thanks in advance
hi all
in my test excel file, on the source column there have lots of name are available. now i want to combined them all in 2 or 3 or 10 words in a cell like the result column, is it possible?
thanks in advance
Please try at D2
=INDEX($A$2:$A$19,ROWS(D$2:D2)*2-1)&" "&INDEX($A$2:$A$19,ROWS(D$2:D2)*2)
thanks a lot Bo_Ry
if i want to get 5 word or 10 word in a cell then what should i do?
5 words
=INDEX($A$2:$A$199,ROWS(D$2:D2)*5-4)&" "
&INDEX($A$2:$A$199,ROWS(D$2:D2)*5-3)&" "
&INDEX($A$2:$A$199,ROWS(D$2:D2)*5-2)&" "
&INDEX($A$2:$A$199,ROWS(D$2:D2)*5-1)&" "
&INDEX($A$2:$A$199,ROWS(D$2:D2)*5)
thanks a lot, its done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks