• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Concatenate multiple Cells into One cell

Afarag

Member
Hello there,

please I ask for how can I concatenate multiple Cells listed vertically into One cell split by ";"

eg:

Login
81287
88446
82395
81284
81296
82311
81251
82368
82363

to be 81287;88446;82395;81284;81296;82311;81251;82368;82363

thanks a lot,
 

Attachments

  • Concatenate.xlsx
    12.1 KB · Views: 6
this is very normal requirement and we discussed this many times on this group.

http://chandoo.org/forum/search/1996046/?q=concatenate&o=date&c[node]=4

https://www.google.co.in/?gfe_rd=c...=ssl#q=concatenate+multiple+rows+in+one+cell

Hello there,

please I ask for how can I concatenate multiple Cells listed vertically into One cell split by ";"

eg:

Login
81287
88446
82395
81284
81296
82311
81251
82368
82363

to be 81287;88446;82395;81284;81296;82311;81251;82368;82363

thanks a lot,
 
Afarag, Good afternoon.

See if this way helps
Excel 2016
Decio
 

Attachments

  • Concatenate Decio.xlsx
    12.8 KB · Views: 8
Last edited:
Back
Top