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

Combine cells horizontally in one cell in list format

F

ferocious12

Member
Hi - I have wrote the formula to Combine cells horizontally in one cell in list format. I have attached the workbook.

The result is in column D. Thought to share if it is useful for someone

64316
 

Attachments

  • concat.xlsx
    10.8 KB · Views: 4
Hi ,

Excel versions after Excel 2010 have the CONCAT and TEXTJOIN functions which are more powerful than the CONCATENATE function. Using them will simplify such formulas.

Narayan
 
You must log in or register to reply here.
Back
Top