Jun 30 2021 09:30 AM
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?
Jun 30 2021 09:42 AM
@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
Jun 30 2021 09:53 AM
Jun 30 2021 01:05 PM
SolutionIf on Excel 365 that could be done by one formula
=CONCAT(TRANSPOSE(names & " "))
Taking into account @L z. comment.
Jul 01 2021 12:05 AM
Jul 01 2021 12:07 AM
Jun 30 2021 01:05 PM
SolutionIf on Excel 365 that could be done by one formula
=CONCAT(TRANSPOSE(names & " "))
Taking into account @L z. comment.