Cant Able to perform Concatenate Operation On Multiple Columns

New Contributor
5 Replies


Perhaps you have line breaks within texts, when expand row height and / or disable wrap text.

As a comment, TEXTJOIN will be easier if it is available in your version of Excel.

What is your excel version?

@Sergei Baklan , i am using this formula



the cell do not have word wrap and looks like no line break is used too

My Excel Version is 2016.


Please check attached file if it works in your environment. Formula is exactly the same, formatting as