SOLVED

Merging three columns (without losing the data) of 22000 rows

Copper Contributor

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

4 Replies
best response confirmed by markdewolde (Copper Contributor)
Solution

@markdewolde 

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!

Hi Hans,
It worked well initially, but for some reason is not working anymore. Any reason why this would stop working?

Cheers,
Mark

@markdewolde 

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?

1 best response

Accepted Solutions
best response confirmed by markdewolde (Copper Contributor)
Solution

@markdewolde 

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.

View solution in original post