Microsoft Excel Merge two columns for Mac

By sleonMicrosoft

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!

Related posts:

  1. Microsoft unveils dual-screen folding Android smartphone
  2. Computer & Monitor Recommendations
No tags for this post.