Forum Discussion

markdewolde's avatar
markdewolde
Copper Contributor
Jan 21, 2023

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...
  • HansVogelaar's avatar
    Jan 21, 2023

    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.

Resources