+ Reply to Thread
Results 1 to 5 of 5

how to combined multiple word in one cell

  1. #1
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2010
    Posts
    127

    Question how to combined multiple word in one cell

    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
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,894

    Re: how to combined multiple word in one cell

    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)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2010
    Posts
    127

    Re: how to combined multiple word in one cell

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

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,894

    Re: how to combined multiple word in one cell

    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)

  5. #5
    Forum Contributor
    Join Date
    07-25-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2010
    Posts
    127

    Re: how to combined multiple word in one cell

    thanks a lot, its done

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Multiple colums with one cell each combined to one column
    By AFITT in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-28-2020, 06:01 PM
  2. Replies: 4
    Last Post: 08-07-2018, 08:30 AM
  3. [SOLVED] Multiple IF functions combined with MID
    By Leon Belmont in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 07-08-2016, 07:09 AM
  4. [SOLVED] Multiple entries combined in one cell
    By Barnapkin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2015, 12:47 AM
  5. Replies: 5
    Last Post: 01-10-2013, 09:51 AM
  6. Combined Excel & Word Report
    By Alan Stuart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2010, 03:37 PM
  7. combined cell data from Excel to Word (2003)
    By Adam in forum Excel General
    Replies: 2
    Last Post: 02-14-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1