Forum Discussion
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 with the First/Middle/Last name all in one cell. But, I don't want to do this 22000 times. 🙂
Hope someone has a quick fix.
Cheers,
Mark
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.
- Hi Hans,
It worked well initially, but for some reason is not working anymore. Any reason why this would stop working?
Cheers,
MarkWhat 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?
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.
HansVogelaar That worked like a charm! Thanks so much! Nice to hear from a fellow Nederlander!
