Forum Discussion

lucaa1355's avatar
lucaa1355
Copper Contributor
Jun 30, 2021
Solved

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's avatar
    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's avatar
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

  • lucaa1355's avatar
    lucaa1355
    Copper Contributor
    Jul 01, 2021
    Thank you very much, it works!! Best regards
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 30, 2021
    As a comment. Whilst there are several options to do it, with thousands of FirstLast names, the Excel cell limit of 32767 chars will likely be reached before the last name

Resources