how to combined multiple word in one cell

**emmr** · 11-27-2020, 06:58 AM

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

**Bo_Ry** · 11-27-2020, 07:20 AM

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)

**emmr** · 11-27-2020, 07:44 AM

thanks a lot Bo_Ry
if i want to get 5 word or 10 word in a cell then what should i do?

**Bo_Ry** · 11-27-2020, 08:16 AM

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)

**emmr** · 11-27-2020, 08:22 AM

thanks a lot, its done

how to combined multiple word in one cell

LinkBack

Thread Tools

Rate This Thread

Display

how to combined multiple word in one cell

Re: how to combined multiple word in one cell

Re: how to combined multiple word in one cell

Re: how to combined multiple word in one cell

Re: how to combined multiple word in one cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Multiple colums with one cell each combined to one column

Combining a word and excel file, keeping a logical pagenumbering when combined in PDF.

[SOLVED] Multiple IF functions combined with MID

[SOLVED] Multiple entries combined in one cell

[SOLVED] extract a word from a cell containing multiple words and placing it in an adjacent cell

Combined Excel & Word Report

[SOLVED] combined cell data from Excel to Word (2003)

Bookmarks

Bookmarks

Posting Permissions