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.
I see how wonderful that solution is, until I need to upload the list without the original columns. If they aren't there, then the data isn't in the column with the merge. Is there a work-around for this?
