• 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.

Excel Help in concatenation

R

Rahul

New Member
How can concatenate the below value like this

A1 A2 A3 A4 A5 A6 A7 A8 Result

2 3 5 6 8 10 =2,3,5,6,8,10


We have to use a formula to concatenate the value. Blank should be left out. When we concatenate the values from A1 to A8. Blank should be left out and result should be shown like above. Also, formula should be generic so that if any new column added, it should be automatically added that column.


Looking forward for your great help.


Thanks in advance.
 
Hi Rahul,


Welcome to the forum. With your data in A1:A8, put this in A9


=SUBSTITUTE(TRIM(A1&" "&A2&" "&A3&" "&A4&" "&A5&" "&A6&" "&A7&" "&A8)," ",",")


For further columns, just auto-fill across
 
Rahul


You may also want to have a read of this post: http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/
 
You must log in or register to reply here.
Back
Top