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 with a double space (see picture). Can anyone help me?

 

 

 

 

excel
Formulas and Functions

5 Replies

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

    • 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