Multiple concatenate function

[i82]

Hi all,
I need to concatenate too many lines, how can I do it by one formula? For example the range of B2:B15

Thanks a lot for your help!

[AlKey]

Here is the trick.

1. =TRANSPOSE(B2:B15) but before you hit enter press F9 and then Enter. Remove {} and replace them with ( ) on both sides of the text and add CONCATENATE in front.Book11.xlsx

[i82]

Thanks a lot it's a great trick!
And how can I separate all the items by comma?

Can you attach the file again? It's very helpful to understand…

Thanks!

[AlKey]

To have commas do not add concatenate function and leave {} in place.

[AlKey]

Thank you for your feedback! (Дякую)