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.

Cheugy

Copper Contributor

Jun 30, 2021

lucaa1355 In column B, enter =A1&" ", drag the formulas down. In column C, use =CONCAT(highlight the referenced cells). See example. You can also copy cells, paste special, and hit the transpose check box. Hope that helps

Book2.xlsx11 KB

lucaa1355

Copper Contributor

Jul 01, 2021

Thank you very much, it works!! Best regards

Forum Discussion

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

Resources