Forum Discussion
markdewolde
Jan 21, 2023Copper Contributor
Merging three columns (without losing the data) of 22000 rows
Hello, I have an excel document with 22000 rows. Column B is the First Name, Column C is the Middle Name and Column D is the Last Name. I want to combine these three columns into one column wit...
- Jan 21, 2023
Let's say the data begin in row 2.
In E2:
=TEXTJOIN(" ", TRUE, B2:D2)
Fill down to the last used row by double-clicking the fill handle in the lower right corner of E2.
markdewolde
Jan 22, 2023Copper Contributor
Hi Hans,
It worked well initially, but for some reason is not working anymore. Any reason why this would stop working?
Cheers,
Mark
It worked well initially, but for some reason is not working anymore. Any reason why this would stop working?
Cheers,
Mark
HansVogelaar
Jan 23, 2023MVP
What exactly is the problem?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?