Microsoft

Microsoft Excel Merge two columns for Mac

Have you ever wanted to combine two Excel columns in Mac? Do you have a platform that only has one column for names rather than taking two columns First Name and Last Name? And now you need to merge them. Here’s how you do it:

  1. Create a new column for the merge values
  2. First cell, call it a name
  3. In the second cell, type out this formula replacing it with the cell values:

=CONCAT(COLUMN1,” “,COLUMN2)

EXAMPLE
=CONCAT(C2,” “,D2)

4. Use command button and drag in new column

And Viola!