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