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

[markdewolde]

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

[#2 · Accepted 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.

[#3]

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

[#4]

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

Cheers,
Mark

[#5]

@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?