SOLVED

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

Copper 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 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

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

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.

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

@Hans Vogelaar That worked like a charm!  Thanks so much!  Nice to hear from a fellow Nederlander!

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

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

Cheers,
Mark

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

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

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

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.