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

Copper Contributor



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.



4 Replies
best response confirmed by markdewolde (Copper Contributor)


Let's say the data begin in row 2.

In E2:


Fill down to the last used row by double-clicking the fill handle in the lower right corner of E2.

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



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?