Forum Discussion
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...
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
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