How do I export text from several cells into one cell with double space?

Hello, I have a list of first and last names (thousands) in excel in column form and I would like (for an artistic creation) to be able to put them all on one continuous line and separate them wi...

excel

Formulas and Functions

SergeiBaklan
Jun 30, 2021
lucaa1355

If on Excel 365 that could be done by one formula

=CONCAT(TRANSPOSE(names & " "))

Taking into account Lorenzo comment.

SergeiBaklan

Diamond Contributor

Jun 30, 2021

lucaa1355

If on Excel 365 that could be done by one formula

=CONCAT(TRANSPOSE(names & " "))

Taking into account Lorenzo comment.

lucaa1355

Copper Contributor

Jul 01, 2021

Thank you very much! This is the simplest way to do it! But it seems that I can not take all the names at once (to big) so I select a few each time. Best regards

Forum Discussion

How do I export text from several cells into one cell with double space?

Resources